Searching subforms...

[Guest]

I have a form which includes two subforms. I would like users of the
database to be able to search on a variety of items...

The main form contains Coordinator Details and I have included a combo box
so that users can look up any entry in the database.

The first subform contains Course Information, so when a Coordinator is
chosen in the main form all the courses they coordinate are listed in the
subform.

The second subform contains Unit Information, so when a Coordinator is
chosen all the units they coordinate are listed in the subform.

I would like users to be able to also search by fields in the course
information and unit information subforms, such as unit/course ID number or
title.

I've tried a couple of things, but none of them have been terribly useful...
If I try to put in another combobox, I can only look items on the main form.
If I try to add a button to the subform which will bring up the find dialogue
box, it doesn't show up when looking at the form.

Any suggestions on how I can do this... easier the better, I'm not a very
advanced user.

Thanks

 

[Allen Browne]

See:
Filter a Form on a Field in a Subform
at:
http://allenbrowne.com/ser-28.html

The article explains how to change the RecordSource of the main form so it
contains only records that have a match in the subform.

You could apply that concept to the 3rd table as well.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...

 

[Guest]

Allen

Thanks for your help... I tried to follow the instructions on the form, but
must've gotten lost somewhere (I have no idea what's going on with all the
code stuf... it looks like latin to me!!) because it didn't work.

Can you make it any simpler for an novice??

Thanks

CastorandPollux

 

[Allen Browne]

The only other alternative I can give you (using subqueries in the WHERE
clause) would look more complex, I fear.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message