requerying a subform

P

Paul Doree

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
 
R

Ron2006

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top