add to cart button

[overlords]

I have a seemingly simple problem that I can't for the life of me figure out. I have a continuous form that is populated by a simple query. On each 'record' in this continuous form, there is a 'cart' button, for when someone wishes to buy the item in question. This button should take the itemID from that record and append it to the 'purchases' table. This is probably super easy, but I've been at this all day and perhaps I just need a fresh pair of eyes to point me in the right direction. Thanks to anyone who can help.

I've attached a picture of the form to help understand what I'm trying to do. Please excuse the colors, I'm color blind.

[June7]

Why doesn't it work, what happens - error message, wrong results, nothing?

Need to see code behind the Cart button.

[overlords]

There's no code behind the button. It's just there as a visual aid. I played with the idea of using an append query but I don't think that's the right path to take, since what I'm really trying to do is single out the item ID of that particular record. I think VBA would be the best option here, which is my problem, I don't know where to start. Or perhaps there's a more obvious solution that I haven't thought of.

[June7]

In the Click event of button select [Event Procedure]. Click the ellipses (...) to open VBA editor at the procedure. Type code, like:

CurrentDb.Execute "INSERT INTO Purchases(itemID) VALUES(" & Me.itemID & ")"

I suspect also need customer ID in there but I don't know your db well enough to be more specific. Include whatever fields you want in the SQL. Syntax example for text, date, number:

CurrentDb.Execute "INSERT INTO tablename(field1, field2, field3) VALUES('" & Me.textbox1 & "', #" & Me.textbox2 & "#, " & Me.textbox3 & ")"