Search form

[Ray]

I am constructing a search form for searching product details. I have an
unbound search form that has two boxes: parts no & supplier. Those two
boxes are linked with a multiple parameter query. After entering a few
known characters in the parts no box, it searches the database for matching
records. We have two parts nos, one is of ours and one of our suppliers so
the database will search both fields and display all matching records. From
that view, we plan to click the parts no of the record in order to display
the details of that parts. The main reason to use this way because the
users always cannot remember exact parts no so they can briefly search the
database and from the search result it can remind them the exact parts no.
Can someone advise me which event procedure I should use to open another
form using the parts no in that field as select criteria.

Thanks,

Ray

 

[Arvin Meyer]

Can someone advise me which event procedure I should use to open another
form using the parts no in that field as select criteria.

You can use the AfterUpdate event of the criteria textbox, but I would think
a command button's click event would be more obvious to the users.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access