Multiple Forms Question

B

Bob Mullen

I have a form that books from 1 to 4 members for events (fields: date,p1,p2,p3,p4). I am using combo boxes to select from the membership. If "Guest" is entered in any of the p1,p2,p3,p4 fields, a prompt for the name of the guest appears and then a second form loads that allows collection of further info about the guest. The guests and members tables are seperate. So far so good

On the booking form, I have an undo record button that undoes the last record as written to the bookings subform. Is it possible to determine whether "Guest" appears in any one or more of p1,p2 ... and undo (delete) the appropriate guest record from the guests table (fields: date, guestname)

Suggestions and assistance is much appreciated

Thanks in advance

Bob Mullen
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Loop to check records 2
Setting field value if a value exists in another table 3
Find MAX Number 9
Group by month 2
Setting field value if a value exists in another table 0
look to do an Offset of something like a offset 2
Best way to check for deletion of data 1
outlook won't boot. 9

Top