Create one search box that will search across tables and fields (1 Viewer)

[mandy4514]

I am trying to create a search box within a form that will search for information in four fields and in two different tables. I have created a query but do not know how to add it my form where I can select fields from either table then have a search box to execute against those fields. Please help me.

 

[John Big Booty]

Perhaps the sample here is doing the sort of thing you are after.

 

[mandy4514]

Thats handy but I want to be able to create the search box within an existing form that when exicuted pulls up that record into the forms fields, even if they were not the exact query question. Does access 2010 have this ability?

Thanks,
Mandy