Running append query adding current record in form.

[AndyJ234]

I've got a generic form with about 12 yes/no check boxs which link to 12 corresponding tables. Upon clicking a check box yes, I want to run an append query to add that current record to it's corresponding table. The problem i'm having is that the query runs to add the record, but doesn't add the record I just added into the form. Where would I apply the query in the form to get it to do this? I've tried after_update but I still run into the same problem.

 

[Rabbie]

I've got a generic form with about 12 yes/no check boxs which link to 12 corresponding tables. Upon clicking a check box yes, I want to run an append query to add that current record to it's corresponding table. The problem i'm having is that the query runs to add the record, but doesn't add the record I just added into the form. Where would I apply the query in the form to get it to do this? I've tried after_update but I still run into the same problem.

You eed to explain your issue a bit more clearly. Can you post you DB to this forum?

 

[AndyJ234]

I'll just use examples. I have a generic form which comes from the table Contacts. One of my checkboxs is for if a patron is a member of our organization. I have a member_tbl which is the table I wish to send the information to. I want the contacts_form to run an append query to add a new record to the member_tbl if the member checkbox is clicked. So if I type in a new patrons details and then click member, it should add it to the table. My only problem is that it does not add this new patrons info because it looks at the contacts table and doesn't see the update yet. Let me know if that makes more sense. I can try and send the DB but it's already filled with some details that I'd have to take out and make up.

 

[AndyJ234]

bump, any ideas?