Prevent auto-load record on subfrom under certain condition?

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.
 
M

Maurice

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
 

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

Similar Threads

disappearing subform (sorry for cross-posting) 2
Using multiple subforms 8
Change Subform based on record selection 3
Cancel the changing to a different record in a subform 1
Complicated (maybe) form question 3
problem adding record to subform 1
How to unhighlight list item 3
subform refresh/requery problem 8

Top