DanT Try to enter =NextCustomerId() as the default value of the CustomerNumber field (in the property sheet). Open the form in design view. Right-click on the field and select Properties and on the Data tab enter =NextCustomerId() in the Default Value property.
HTH Liveson ----- Original Message ----- From: ttcdan To: [email protected] Sent: Friday, 06 April, 2007 12:08 Subject: [ms_access] Entering a value into a field with a function I have a function, NextCustomerId(),that adds 1 to the last customer number in my "Customer" table. It works. Debug.Print displays the number that I want. I want to make this number the value in my "NewCustomer" form "Customer Number" field. How do I do this? Thanks DanT [Non-text portions of this message have been removed]
