Searching & Subforms

  • Thread starter Thread starter Fie
  • Start date Start date
Fie said:
How do you preform a search on a form and display results in subform
Click to expand...

If you aren't compelled to use a subform, the Combo Box wizard has an option
to use the Combo Box to search and display the selected record on the main
Form.

If you really want a Subform, you can set the MasterLinkFields to refer to
the Combo you use to Search and the ChildLinkFields to the corresponding
Field in the Data displayed in the Form embedded in the Subform Control, and
it'll be more-or-less automatic.

Larry Linson
Microsoft Access MVP
 
You must log in or register to reply here.

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

Main Form and two Subforms 2
How to always get the top level form reference, when calling from any subform/subform... 0
Display Results from a select query in a subform 1
Unremovable horizontal scroll bar on subform 1
Searching for a record on a subform 1
Need help on how to pass calculated field from a form to another form 0
Find button on main form that searches a subform. 1
Searching with a text box 3

Back
Top