Thanks , that was the solution. I was going in that direction but kept missing it. --- L Tumbulu <[EMAIL PROTECTED]> wrote:
> 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] > >
