I have a subform in my main form and I'm controlling the subform's recordsource using a ComboBox and some VBA code. Whenever a group is selected from the combo box, the record source on the subform is set to show each instance of that group from a table.
My problem is that when I close the form and reopen it, the subform show's the record that was last looked at. I tried doing a requery on the subform on tee main form's Open and Load properties but it didn't work. How can I get it to open up blank every time?
My problem is that when I close the form and reopen it, the subform show's the record that was last looked at. I tried doing a requery on the subform on tee main form's Open and Load properties but it didn't work. How can I get it to open up blank every time?
