...HELP!
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?
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?