Requery not working

[jketcher]

Back again... New subject. Tabbed form with 'Client' selected on first tab and used on the other tabs. The fourth tab (Run Reports) has a subform that uses the client to query records but when the client is changed, the records are still for the previous client. The client change shows on the form but subform data not changed. I know this is a requery problem but attempts to fix have failed. When and how do I do this? I have tried a 'click' event on the 'Run Reports' tab that requeries the client, but it has no impact on the query used for the subform.

Thanks, jketcher

 

[pbaldy]

The most bullet proof solution would be to set the master/child links of the subform control. The requery would look like:

Forms!MainFormName.SubFormControlName.Requery

 

[jketcher]

This worked on the After Update event of the Client change. Thanks!