Exicute an append query in an after update event

Apr 3, 2012
Reaction score
without being too lengthy. I want a subform to populate after a combo box on the main has been updated. I have built an append query to drop the data in the table the subform is based on. I want this query to execute and refresh the sub-form automatically though. At this time I have to select an item in the main form combo box, click in a field in the sub-form, double click the append query then click refresh just to get the sub-form to populate. How can this be performed utilizing the after update event of the main form combo box?

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