Here is my question,
I have a field called "MemberID" with the default value at "NM".I need to put a number in this field also becuse there are 800 NonMembers. So can someone please tell me the
best way to end up with the MemberID having the results of "NM0001" and will autonumber for new records . Hope this made since http://www.access-programmers.co.uk/ubb/smile.gif

thank you,
Ken Mc

Have an bound list box displaying 'Members' and 'NonMembers' to a field in your table. Have an ID field that is Autonumber. The form will be based on a query that concatonates these two fields.

TheID:MemType & AutoIDField