Requery a subform
Posted on 2013-12-09
I have a form with 3 subforms. There is no recordsource in the main form. Subform Master/Child links are linked to text boxes in the main form.
In general, when I select a record in subform 1, subform 2 updates to show a new set of records based on my subform1 selection. I then select certain records in subform2 via a checkbox in each record then run an append query via a Button On-click Event to add the records to the table in subform3. Everything works fine except I cannot requery subform3 to show the new records. Access does not like my Requery commands any way I put them.
(if I exit the form then re-open the records are there).
Can someone please help with a VBA or macro to update subform3. Current focus is subform2 but I want to requery the records in subform3 using a macro or VBA.
Help is much appreciated.