using button to modify single record?

the_adam

New member
Local time
Today, 00:25
Joined
Apr 13, 2009
Messages
1
Hi all,

I have a different barcode set for every record in a table. I'm basically trying to design a form where I can enter that barcode (and a number in a seperate text box), then have a button linked to add the number to a field in the record that the barcode applies to. Hope that makes some sense :) Havn't had much luck so far, I'm fairly new to using access so any advice would be appreciated.

Thanks, Adam
 
I'm not clear on exactly what you want to do, but it sounds like this might be it:

CurrentDb.Execute "UPDATE TableName SET FieldName = " & Me.TextboxName & " WHERE BarCodeField = '" & Me.BarCodeControlName & "'"

which presumes the barcode field is text.
 

Users who are viewing this thread

Back
Top Bottom