I need a little help writing a script. I don’t think it is complicated. However, I have managed to confuse myself the last three weeks reading about Access and trying to figure it out.
I have written a DB for an antique radio conference. They host two auctions. I have a form called Settle Auction, which shows what someone has bought and sold. It is based on two tables.
tblNameList-holds name, address, etc. information. The primary key is called ID.
tblAuctionItem-contains all the information about what was bought and sold. The field Buyer_ID joins to tblNameList and has the same value. It also has a field named PAID.
From the form SettleAuction, I can print a receipt for the auction items. With the click of a button, the report rptReceipt opens and is filtered on a particular ID. This part is working fine. I am trying to write some code that when the report is closed, the field PAID (in tblAuctionItem)will be updated to contain today’s date. I need this to be done for every item purchased by that person. This can be anywhere from three to 100 items.
For example, buyer number 252 is ready for check out. I open SettleAuction to number 252. I then click a button to open rptReceipt which opens to number 252. I print the receipt. When I close the report, I want today's date to be placed on tblAuctionItem for the three items that buyer 252 purchased. I hope that makes sense.
Any help would be greatly appreciated.