Refresh subform that is generated from query

[Kevo]

Hi all,



I have a form with 2 subforms.....the first form is for entering details of a "load" - (what items are placed in a sterilization load) - I use dependant comboboxes on this one and had to minimize the view so that the user only sees one record at a time (because of cascading comboboxes and how they lose focus when you go to the next combobox)


Because the first form is minimized and I still wanted the user to see the "List" of load details as they enter it.....I created 2nd subform based on a query of the table that is populated with the first subform.


Now what I am trying to do is have the 2nd subform "Requery or Refresh" after user tabs out of last field in record "quantity"


Any ideas? I have attached the DB for your amusement.....any ideas for improvement in design is also appreciated.


Thanks,
Kevin


PS - the form I am having trouble with is frmLoad....... from Main menu go to "Sterilization Menu"....then "Edit Load Log"

[TG_W]

Add Me.Requery as an AfterUpdate after the last combo box. That should do it.