In Access2010, how do I set instructions (macro) in the data entry form to incrementally fill in the next number of my Member ID number field? The number used contains three letters followed by six numbers.
The data entry form collects typical information, i.e. last name, first name, address, phone, email, etc. It's control source is my tblMain which holds all the information.
I know nothing in terms of SQL statements, VB, writing macros. I don't know what to do with the macro builder. Can someone work with me to "build" the correct macro?
Let me know if there is more I need to explain that will help.