passing criteria via form

  • Thread starter Thread starter Mike M.
  • Start date Start date
M

Mike M.

I want to use a form to display a single record from a query using the input
specified by the user. I thought there must be some simple way to pass the
input to the query as criteria to select the record, but I can't seem to
figure it out. I don't have any coding skills to speak of. Is there a
simple solution?

Mike
 
If you are going to code a form to search, then you can try the following:

http://www.members.shaw.ca/AlbertKallal/Search/index.html

In the above, we build a continues form, and note the little glasses
"button"

The code behind the button to "pass" the criteria to form looks like:


docmd.OpenForm "frmEditCustomer",,,"id = " & me!id

It only takes one line of code...and note how the above passes a 'where'
clause to the form.....

Thus, the above form will open to the one record id I set....
 
Back
Top