Elly
December 14th, 2003, 10:25 PM
I'm working in Access 2003.
I have two forms with 7 fields. Date (date field), cust1(text), cust2(text), cust3(text), cust4(text), time(date/time), and 18holes(Checkbox). The underlying tables are prepopulated with a years worth of dates and times. So when I run the forms (as subforms on a parent form), I see a years worth of records with each day having many times "available". One table/form is for the front 9 holes and the other for the back nine holes of a golf course. These subforms are on a form that is linked to a dates table. So for each day, the subforms will display many times and 4 customers for each. The customer fields are empty for now. What I want to do is this: When the customer names are filled in, and the 18 holes check box is checked, I want to copy those customer names to the other table with an available time. To help clarify this - this is for tee time reservations. When a customer is going to play 18 holes of golf, his name is entered in a record in table one and the 18Holes checkbox is checked. The name should then be copied into a record 2 hours later in the day on (table 2) the opposite set of holes (back or front). So the question is how do I copy parts of one record into a specific record that already exists in another table. Part of the problem is finding the correct record to enter data into in the second table.
I would appreciate any help you can give me. I know just enough VBA to muddle through, so if this gets complex, I might need a little handholding
Thanks so much for any help!
Elly
I have two forms with 7 fields. Date (date field), cust1(text), cust2(text), cust3(text), cust4(text), time(date/time), and 18holes(Checkbox). The underlying tables are prepopulated with a years worth of dates and times. So when I run the forms (as subforms on a parent form), I see a years worth of records with each day having many times "available". One table/form is for the front 9 holes and the other for the back nine holes of a golf course. These subforms are on a form that is linked to a dates table. So for each day, the subforms will display many times and 4 customers for each. The customer fields are empty for now. What I want to do is this: When the customer names are filled in, and the 18 holes check box is checked, I want to copy those customer names to the other table with an available time. To help clarify this - this is for tee time reservations. When a customer is going to play 18 holes of golf, his name is entered in a record in table one and the 18Holes checkbox is checked. The name should then be copied into a record 2 hours later in the day on (table 2) the opposite set of holes (back or front). So the question is how do I copy parts of one record into a specific record that already exists in another table. Part of the problem is finding the correct record to enter data into in the second table.
I would appreciate any help you can give me. I know just enough VBA to muddle through, so if this gets complex, I might need a little handholding
Thanks so much for any help!
Elly