G
Greg
I am working on an auction database where each buyer has a buyer number. I
have a buyer receipt that prints. When I click on the Buyer Receipt button a
select query parameter requests the buyer number. A criteria is than set for
that buyer number and the receipt prints. While the criteria is set I would
like to update the database on two fields - one called "Receipt" which is a
Yes/No and the other called "Printed" which I update to "Receipt printed:
"&Date()" to get a time stamp on the receipt time. Later in the reports I
will print out that a receipt was printed and when.
How can I update the database while it is open with the criteria set to the
correct buyer number? I can do another parameter call in an update query and
enter the buyer number again. Is there a way to pass the buyer number to the
update query so I don't have to put in the buyer number twice? Or is there
another way just to update those two fields while the database is open?
Thanks for any help.
have a buyer receipt that prints. When I click on the Buyer Receipt button a
select query parameter requests the buyer number. A criteria is than set for
that buyer number and the receipt prints. While the criteria is set I would
like to update the database on two fields - one called "Receipt" which is a
Yes/No and the other called "Printed" which I update to "Receipt printed:
"&Date()" to get a time stamp on the receipt time. Later in the reports I
will print out that a receipt was printed and when.
How can I update the database while it is open with the criteria set to the
correct buyer number? I can do another parameter call in an update query and
enter the buyer number again. Is there a way to pass the buyer number to the
update query so I don't have to put in the buyer number twice? Or is there
another way just to update those two fields while the database is open?
Thanks for any help.