Well, pretty much what the title says. Here is the flow:
Unbound Textbox submits string of numbers/letters to VB based on an event (BeforeUpdate)
A SQL string will update the DB date field where the submited string matches
The user will now be ready to repeat the same process.
Here is the SQL statement that I am trying to use:
strSQL = "UPDATE inventory INNER JOIN invHistory ON inventory.ID = invHistory.invID SET inventory.inOut = True, invHistory.dateIn = Date() WHERE inventory.serialNumber = " & StringFromUnboundTextBox
How do I get the submitted value to do use that SQL string with Access?