Update Query Parameters

[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

 

[Rick Brandt]

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?

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.

 

[Douglas J. Steele]

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)

 

[Marie]

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

Qui êtes vous ?