four parameters in form for query in subform, subform does not change? Help?

[Matthew Pilkington via AccessMonster.com]

Problem? I have a query that runs on FOUR parameters in a form:
2 combo boxes and 2 text boxes,
but when the parameters are selected the subform does not change
The query runs fine though just the subform does not refresh
it does change however when i set the parameters then go into design view
and back to form view

any help would be greatly appreciated

Thanks

Mat

 

[Van T. Dinh]

If you are not using the LinkMasterFields and LinkChildFields of the
SubformControl, you will need to use the AfterUpdate Event of each Control
to re-query the Subform.

OTOH, if you use 4 Controls (2 ComboBoxes + 2 TextBoxes) in the
LinkMasterFields and 4 correspondent Fields from the Subform's RecordSource
in the LinkChildFields of the Subform Comtrol, Access will re-query the
Subform automatically for you. In this case, you need to remove the
criteria using the above Parameters from the Query / SQL being used as the
RecordSource for the Subform.

 

[Matthew Pilkington via AccessMonster.com]

do i just type "me.subform1.requery" ?
thanks for your help

 

[Matthew Pilkington via AccessMonster.com]

Thanks Sorted!!!!!!!!!!