forms question - account number

[burnout]

I have a list of account numbers for members, they have distinct member numbers. I have it set up for users to search for the member, then the member number will auto-populate. I also need to account for members with no member number. I would like to have the user click on the check box "Non-Member" and somehow assign a Member number...starting with NM. So the first non-member would be NM00001, next NM00002. I thought I could create a table with the sequence of NM numbers. I am just unsure of how to tell my form to populate that field when the Nonmember box is checked.

Any ideas?

 

[FoFa]

If the NM number have leading zeros you can use
MaxMemNo = DMAX("memNo","MyTable","MemNo like 'NM*'")
to return the last one used, and a simple calculation:
Me.memberNumber = "NM" & str(val(right(MaxMemNo,len(MaxMemNo)-2))+1)

i think