InputBox in Where Statement

[Casey Howlett]

Need info please.
I am trying to look up a specific service order so that I can update info
after the job is complete. I am using a OpenForm Macro with a query filter
to do this. Is it possible to use an InputBox from the Where clause to
prompt the user for the service order number, or do I have to design a
seperate form for this. If it is possible could someone show me an example
of the syntax that I would use in the where clause.

TIA
Casey Howlett

 

[Douglas J. Steele]

In the query on which your form is based, put something like [Service Order
Number?] (complete with the square brackets) as the Criteria for the service
order number. A pop-up, virtually identical to the InputBox, will then
appear whenever the query is opened.