Default value

A

And

Hi everyone!

I have this problem that I am trying to solve for a few days.

In a form I have a text box in which I want to have a sequential number
depending on the biggest number of this field. This field can't be of the
auto number type since it must be able to have changes.

I tried to solve this in this way:

I put in the default value of the control the expression:
Max([field])+1. But this only worked if I have another control with that
value: (Max([field])+1) and only if I add one record each time.



Can someone help me

Tks in advance

Andy
 
A

And

I did it!!! :)

I put in the deafult value the expression:
=DLookUp("Max([fieldname])";"table";"")+1

Tks any way
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to set the Default Value of a Control Box to a Lookup Table 0
Setting the default value for a data field using a calculated valu 1
Default Value on Form Help 1
Validate the number of checkboxes that can be true 0
Max function manfunction. 5
Find Next Available Number and Set Value 6
User Sets Control Default Value 1
Default value problem 2

Top