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.

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

"jlo" <(E-Mail Removed)> wrote in message
news:EE9268D8-6F3A-48DB-B1EE-(E-Mail Removed)...
> 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.