use query to provide value for data entry

Microsoft Access 2010 - windows
November 16, 2010 at 02:33:38
Specs: Windows XP
I have a DataEntry form into which I want to enter customer details such as name address etc. I want the customerID to be visible on the screen but not editable. I can't use AutoNumber to generate the customerID (long story), but I want it to be sequential. I have a query which selects the max id and adds one but I'm struggling to see how I can use this to prefill my customerID field on my form.

See More: use query to provide value for data entry

Report •

November 16, 2010 at 06:20:10
A simple way to do this is to use the Default Value property to set the ID and set the Enabled property to No.

Report •
Related Solutions

Ask Question