Updating a table

bigbadbess24

Registered User.
Local time
Today, 08:13
Joined
Mar 9, 2006
Messages
83
I want to create a form that will update a table. I have two columns, an item number and a paid column. On the form I want to plug in the item number and then I want to hit ok and it will find that item number and put a value (for example "X") in the paid column.
I have tried running an update query when i hit the ok button but I can never get to work
 
This is what I have now. I need something to link it to the item. My other column is Item Number.
UPDATE tblDescription SET tblDescription.[Printed Recipt] = "X"
WHERE (((tblDescription.[Printed Recipt])=[Forms]![frmPaddleWinner]![Paid]));
 

Users who are viewing this thread

Back
Top Bottom