Button to search table with any field in form

[sephiroth2906]

Hello all!

I am a real noob here, so if this is simple, please forgive me.

I have a table for logging entries of copies made. I have a form that we are using to update that table. The form has all of the same fields as the table, so all of the entries are made there to avoid anyone who knows less than me (if that were possible) to accidentally mess up anything on the table.

I have made some buttons to do various things on there, but I would like to have one that performs a search for a record based off of whatever fields have been filled in by the user, basically the equivalent of right clicking a field and choosing the "Equals" option. When I choose the "Equals" option from the context menu, it simply pulls up the matching record in the form and all of the associated fields. If there are more than one match, I can click next record to view it. I would like my button to simply tell the form to search "Equals" to the entered field(s).

I am eager to learn and would appreciate any help you might be able to give me.

Thanks!

[pbaldy]

One option is demonstrated in the sample db here:

http://www.baldyweb.com/BuildSQL.htm

[sephiroth2906]

*Sigh*
I was hoping to avoid scripting. I knew I was going to have to learn eventually, but I guess the time has come. That link went so far over my head that it hit an airplane.

Anyone have any good tutorials they can recommend for me online to start learning vba?

[pbaldy]

Oh, there are other ways (though I'd dive in and learn VBA). You can use this technique in a query to only consider fields that have been filled out:

http://www.mvps.org/access/queries/qry0001.htm