Hey,
When I enter a UnitId on the form followed by a Serialnumber. I have a button to click on that changes the status to 'Assigned' on my lookup field.
Private Sub Assign_Click()
[Sim_Serials_All_Subform].Form![SimStatus] = "Assigned"
End Sub
Which works quite fine if you do it manually with the button.
However the user wants to import a spreadsheet in - meaning they don't fancy clicking the button 2000 times
So is there a way of losing the button and doing it automatically as soon as the serialnumber is entered?
If any further info is needed..Let me know
Thanks