Combo box to search on a field in the subform

J

jlo

Is it possible to have a combo box search for a field that is the located on
the subform? I already have a combo box search for a field that is on the
main form however the customer would like to have a search option for a field
that is located on the subform. This is making me crazy so I thought I would
ask if it's possible. Thanks.
 
A

Al Campagna

jlo,
Make that task a lot easier by placing a search combo in the Header of
the subform.
Then, you can use the same procedure you used on the main to do the same
type of search in the subform.
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 

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

Code to Search by Field in Subform 1
Subform dependent combo box 4
filter query on combo box in a continuous subform 0
First Subform record gets modified when closing form 3
Combo box Subform Control Default 2
OnClick on Combo Box opens a New Form 0
Dependant combo box in subform 2
record search with combo box. 1

Top