requerying a subform

Hi,

I have a main form with two sub forms on it.

The recordsource of the second subform has in it's criteria a reference to
the JobID of the first i.e. forms!MainForm!Subform1!JobID. If I put a
button on the main form and requery Subform1 from it all is well - Subform2
results update to reflect the job selected in Subform1

What I need, though, and I'm struggling to find, is the syntax to requery
the second subform from the on current event of the first subform.

Help appreciated

Paul

If you have the LinkChild/MasterFields set up correctly then the requery
should take place automatically by Access.

Paul Doree wrote:
Hi,

I have a main form with two sub forms on it.

The recordsource of the second subform has in it's criteria a reference to
the JobID of the first i.e. forms!MainForm!Subform1!JobID. If I put a
button on the main form and requery Subform1 from it all is well - Subform2
results update to reflect the job selected in Subform1

What I need, though, and I'm struggling to find, is the syntax to requery
the second subform from the on current event of the first subform.

Help appreciated

Paul

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200803/1

The key is that you don't have the criteria expressed in the query
itself.

Instead you place the field names of the parent field and the child-
subform field in the master/child parts of the Data tab of the subform
as it resides on the mainform (the parent form).

If you do it that way no re-query is required.

Ron