B
Bob Richardson
My main form has two subforms, SubA and SubB.
SubA is a simple Datasheet view to change the TimeSlot file.
SubB uses a combo box, where the pick list is based upon the values in the
TimeSlot file. The combo box uses Q_TimeSlotPick as the RowSource query,
where the TimeSLot criteria is
[Forms]![EventForm]![EvCode]
(EventForm is the main form)
When I make a change to the TimeSlot file in SubA, those changes aren't
reflected in the SubB combo box, unless I close the EventForm and then
reenter it.
What do I need to requery, when and where?
SubA is a simple Datasheet view to change the TimeSlot file.
SubB uses a combo box, where the pick list is based upon the values in the
TimeSlot file. The combo box uses Q_TimeSlotPick as the RowSource query,
where the TimeSLot criteria is
[Forms]![EventForm]![EvCode]
(EventForm is the main form)
When I make a change to the TimeSlot file in SubA, those changes aren't
reflected in the SubB combo box, unless I close the EventForm and then
reenter it.
What do I need to requery, when and where?