Form Search Question

[byron09]

I created a simple form in access that allows me to scan a barcode to see if there's an allocation on it. The issue is that after I scan the barcode I I have to click on twice on the barcode field to scan over the previous barcode.

Is there a way to have access do the following

scan the barcode, then scan a new one over it without having to select+delete?

 

[georgedwilkinson]

Yes, in the object's Got Focus event, do a seltext. Then the new barcode will overwrite the old one.

 

[byron09]

I can't get it to work. The field is called MLP. How would you write it?

 

[georgedwilkinson]

You're right, seltext doesn't do that. I've experimented with a couple of things on your behalf and came up with this:

Private Sub MLP_GotFocus()
        Me.MLP.Value = ""
End Sub

This will set the value of the control named MLP to nothing, enabling you to enter a new value without having to muck around with the old value.