Keyword Search Form

[brsawvel]

Hello,

I have a form with three subforms that display three separate tables. I know there's a way to do it, but I haven't figured it out... I'd like to have a unbound textbox and button where I can enter a keyword into the textbox and On Click, the three tables filter to only those records containing that keyword?

 

[pbaldy]

I'd create SQL using the textbox value and set the RecordSource property of the 3 subforms appropriately.

 

[brsawvel]

I'm guessing the SQL is something like SELECT tbl WHERE "keyword", but how do is set the RecordSource property of the 3 forms appropriately?

 

[brsawvel]

*"how do I"

 

[pbaldy]

Does this help?

http://access.mvps.org/access/forms/frm0031.htm

By appropriately, I mean each has to refer to a different table.

 

[pbaldy]

I'll get out of the way.

 

[brsawvel]

Thank you to the both of you!