Subform Help

  • Thread starter Thread starter Froto
  • Start date Start date
F

Froto

Here is my problem. I have a search form with several
search options for users. What has bee working is once
the user selects a name and clicks the search button, a
separate form would open with the results. What I would
like to happen is place this form as a subform in the
main search form. I have this code placed behind the
onclick event of the button.

DoCmd.OpenForm "SearchForForm", , , "([submitter] = '" &
Me("txtname") & "')"
txtname = ""

I would Like to change this code to show the results of
the searchforform as a subform in main form without it
opening as a separate form. Hope this makes sense.

Thanks
 
Froto said:
Here is my problem. I have a search form with several
search options for users. What has bee working is once
the user selects a name and clicks the search button, a
separate form would open with the results. What I would
like to happen is place this form as a subform in the
main search form. I have this code placed behind the
onclick event of the button.
Click to expand...

There are examples of similar things in the Northwind database.
There is no need for a search button.
The results of your search should place the key to the record in a (hidden)
field on your main form and this form would serve as the master field.
 
Back
Top