Prevent auto-load record on subfrom under certain condition?

  • Thread starter Thread starter lord
  • Start date Start date
L

lord

Hi!

I have 1 form and 2 sub forms.

Form -> searches for recordID
Subform1 -> searches for itemID based on recordID selected in the form
Subform2 -> displayes information for itemID that was selected in Subform1

At the moment I am having an issue of where as soon as the recordID was
selected in the Form, Subform2 automatically displayes the first record it
finds in Subform1 even though no specific record was specified in Subform1.

Is there a way to make Subform2 show record only when Subform1 is selected.
 
In that case you should link your subform 2 on subform 1 and not to the main
forms because that's the way it sounds like you have set it up right now...
Also that's the way the master childfield works as soon as you make a change
the dependency will go to work and in most cases record 1 will show up
 
Back
Top