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"

 

[Uncle Gizmo]

I have compiled three sets of YouTube videos (Play Lists) which demonstrate how to build your own search form from scratch...

If you watch the last set of videos first:- Microsoft Access - Easy Search Criteria

You will see an example with option groups.

The three play lists cover the subject of a search form from a simple example to a reasonably sophisticated solution. You should be able to find a level that suits you.

MS Access - Building Search Criteria
MS Access - Building Advanced Search Criteria
Microsoft Access - Easy Search Criteria

I think the first playlist should cover what you want, but you can take it much further if you feel the need.

BTW, these examples are for just one subform, you should be able to modify it to pass the SQL statement to all the subforms.

Also if you want to search every field for the same search term, then that should be a simple modification.

If you get stuck and need help, then post the video url and the time index and I can, advise you...

Sent from my SM-G925F using Tapatalk

 

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

 

[Uncle Gizmo]

I'll get out of the way.

You're not in the way! I'm the interloper!

Sent from my SM-G925F using Tapatalk

 

[brsawvel]

Thank you to the both of you!