Query design - "Enter Job Order Number"

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

Hi,

I've setup a query to list one record related
to "JobOrderNo", with the following statement in the
criteria field for the JobOrderNo field in the JobOrderF
form. The statement reads:

[forms]![JobOrderF]![JobOrderNo]

I get a "parameter value" box that reads:

forms!JobOrderF!JobOrderNo

I can put in the specific job order number and print its
record. But, I am perplexed on how to change
the "parameter value" statement to say, "Enter Job Order
Number".

This may sound very simple to most of you Access gurus but,
I am going bald...scratching my head on this one.

Please email me if you would like to see the database for
yourself.

Help!!

Thanks,

Bob
 
Is the Form "JobOrderF" open when you run the Query? You need the Form to
be open when the Query is processed.

Are you running the Query through the GUI or by code, e.g. creating a
Recordset based on the Query? If you run the Query though GUI, it should
work as the Expression Service will resolve the reference to the Control for
you.. If you use the Query to create Recordset, the Expression Service is
NOT available and you need to resolve the reference by code before passing
the Query / SQL to the JET database engine for processing.
 
I'm no expert either Bob but I think I can help. Open your query in
design view and in the criteria box for the "joborderno", type [Enter
job order number] or whatever text you want. When you run the query you
will be presented with a data entry box for the job order number and
the text on the box will be whatever you typed inside the square
brackets.
Hope this helps
Tintin (also going bald with Access assistance)
 
Back
Top