Command Button to clear

[danian]

I have a command button (cmbBarcodeEnter). After update i want the it clear itself of text and the be ready for the next barcode to be entered. At the moment the button updates and then tabs to next button and leaves the text in the cmbBarcodeEnter button.

Thanks
D

 

[astarbyfar]

I think what you want is for the user to be able to enter a record then save this record and begin entering another record. If this is correct what Id do is have a macro on your command button which will close and reopen the form you are working on. This way, access will automatically save the first record as a prompt and will open the new form for you to be able to enter the second record.

Hope this helps

 

[jkl0]

If your form is bound to a table or query then,
In the On Click property of your command button, after the (VB) command to save the record, insert the following line:

DoCmd.GoToRecord , , acNewRec

That will take you to a new blank record, ready for new input. And if it doesn't go to the textbox that you want it to go to, also put

Me.yourTextbox.SetFocus

Hope this helps.