I could use a pointer, I spent the past 2 days trying to get a form in Microsoft Access to use VBA to Create a new record from an Access Datasheet view, I am scanning a barcode in a combo box with a carriage return, then using on_exit to set focus to the next textbox that has a query combining the title, condition, description and price from the bar_code_id. The problem I am having is that I want the datasheet to then start a new blank line ready to accept another barcode input, I cannot get it to open a new row. If I inhibit the on_exit function of the combo box all I have to do is press the enter key a new blank row is opened with the cursor in the right position and I am ready for another barcode but I don’t perform the query. Any suggestions would be greatly appreciated.

Move to the last row, then movenext.

To discover the code to do this, create a macro that does this (using the drop-downs that the macro editor provides), then convert the macro to a procedure.

Alternatively, you could create a button on the form which adds a new record using the control wizard, then utilize the code the wizard generates for creating a new record in creating a new record through your process.

Brian,
 Thank you for the feedback, It is amazing how something so simple could elude me for so long. I used the button wizard to add a new record an then cut and pasted the code. I had already tried, Move to the last row, then move next in code, that did not work. I don't know how to use the macro builder, so I didn't even try that.