Hi,
I have a form with a subform. I don't want to use autonumber for my [ReferralNumber] field because I don't want the records to start at 1. But I would like to have the field autopopulated with a number each time I open a new form. So if I decided to have the referral number begin at 100 and increment by 1 with each new form that opens how would that look?
Thanks,
Lynn