I have been asked to create a application. VB is the only way I know how to get this running while using access. Any way I have a textbox - Text1, when a person scans in a SKU number I would like it to search a database and find that SKU number then increment another field by 1.
I guess my question is that would it be better to use onChange with SELECT command or GotFocus? And how do I incorporate the SELECT command.
I do not want the person to have to click on anything. Just automatically increment on each scanned sku number.