Update Query Parameters

  • Thread starter Thread starter Glenn Peters
  • Start date Start date
G

Glenn Peters

I have an update query, that displays a prompt for a user to enter a
quantity. At the moment when the query is run, it looks shows this:

[Stock]![QtyOnHand]+[Forms]![frmOrder]![fromOrderItems].[Form]![Qty]

Is there anyway to make this a bit nicer, by displaying something like
'enter quantity' instead?

G
 
Glenn said:
I have an update query, that displays a prompt for a user to enter a
quantity. At the moment when the query is run, it looks shows this:

[Stock]![QtyOnHand]+[Forms]![frmOrder]![fromOrderItems].[Form]![Qty]

Is there anyway to make this a bit nicer, by displaying something like
'enter quantity' instead?
Click to expand...

It is only displaying a prompt because the query contains a reference it
cannot find. If the form in that reference were opened (as it should be)
when you ran the query you would not be prompted.
 
The reason you're getting the cryptic prompt is because frmOrder isn't open
when the query runs.

If you need to be able to run the query without the form being open, you can
replace [Forms]![frmOrder]![fromOrderItems].[Form]![Qty] with something like
[Enter quantity].

In either case, assuming Stock is the name of your table, I'd recommend
changing [Stock]![QtyOnHand] to [Stock].[QtyOnHand] (in other words, change
the exclamation point to a period)
 
Glenn Peters said:
I have an update query, that displays a prompt for a user to enter a
quantity. At the moment when the query is run, it looks shows this:

[Stock]![QtyOnHand]+[Forms]![frmOrder]![fromOrderItems].[Form]![Qty]

Is there anyway to make this a bit nicer, by displaying something like
'enter quantity' instead?

G
Click to expand...
Qui êtes vous ?
 
Back
Top