updating records from code

[mech55]

Basically, I need to update a certain record to be 'closed' when I hit a button depending on the 'serial number' that is typed in the text box above. I'd like not to bind the form to anything however. How can I do this?

thanks,

 

[FoFa]

You could create an update query using the serial number field as a parm and just run it via a macro/vba, would the easiest.

 

[mech55]

would it be best however, as far as design purposes? Would there be a performance hit in compareson to running vba code?

 

[FoFa]

Actually I think the query would run faster, but either most likely will run fast enough since you are only updating one row you would not notice as long as it is designed properly. If were updating mulitple rows, I would say the query has an advantage in speed.