DoCmd.RunSQL

[Access_Blaster]

I have a list box that I can filter serial numbers with and it works great. Once the serial number is found and printed, I update the "printed" Boolean field with TRUE.

CurrentDb.Execute "UPDATE TblWalker SET Printed = true WHERE ID = " & Forms!FRM_SearchMulti!SearchResults.Column(0)

How do I update the "Room" field at the same time? I can't get my code to insert into the filtered record, or the current record. It does however insert into a new record.

DoCmd.RunSQL ("INSERT INTO tblWalker ([room]) VALUES (room.value)")

I want to use CurrentDb.Execute for this but no love either. Any help is appreciated.

[June7]

Update as many fields of a record as desired. Is Room a number type field? Where is the room value come from?

CurrentDb.Execute "UPDATE TblWalker SET Printed = true, Room = " & Me.room & " WHERE ID = " & Me.SearchResults

Are Printed and Room fields included in the form RecordSource? If so, there is no need for the UPDATE sql action.

Set values of fields of current record with:

Me!Printed = True
Me!Room = some input here

[Access_Blaster]

June thanks for the response, this is a list box so me!printed doesn't work because the form is unbound with a list box control. The code in green works great, but I need an input box to put a variable in. The room is text but the input could be 201 or Main office, the Printed field will always be true if printed. This needs to happen while I have the filtered record visible in my list box.

[June7]

So you have solution with the multi-field UPDATE sql action?

[Access_Blaster]

So you have solution with the multi-field UPDATE sql action?

I need to use a input box to update the room field. Any suggestions?

[June7]

Maybe a textbox or combobox on the form next to the listbox?

[Access_Blaster]

Thank you figured it out.