use vba to add a row to datasheet
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.