Query design - "Enter Job Number"

[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

 

[Jeff Boyce]

Bob

You posted in the .tablesdbdesign newsgroup -- not sure how your question
relates.

However, what you've described is a way to have your query look at a control
on a form to get its criterion. If the prompt you are getting is
forms!JobOrderF!JobOrderNo
that means that your form must not be open when you run the query ... hence,
the prompt.

From my experience, you can't have it both ways. Either you use a parameter
in your query that looks at a form (as yours does now), but "chokes"
slightly when the form isn't opened (and the control value present), or you
change your query's criterion prompt (i.e., "parameter") to something like
[Enter Job Order Number]

Good luck

Jeff Boyce
<Access MVP>