Generate numbers in order

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I really need help, i have this DB and i have create a form that u can enter
information in this form and get stored in table i have called this form "
add " and they get stored in table called " info ",in the form i have feild
called Ref No and i want that number to Generate in order for each time i
fill form and save in the table?

Plz help. thank u very much and i will be looking forward to hear from u.
 
Hassan Merzha said:
Hi

I really need help, i have this DB and i have create a form that u can
enter
information in this form and get stored in table i have called this form "
add " and they get stored in table called " info ",in the form i have
feild
called Ref No and i want that number to Generate in order for each time i
fill form and save in the table?

Plz help. thank u very much and i will be looking forward to hear from u.
Click to expand...

Set this as the text box's default value:

Nz(DMax("UniqueNo", "qryMyQuery")) + 1

where "UniqueNo" is the name of its field and "qryMyQuery" is the name of
the form's query.

Regards,
Keith.
www.keithwilby.com
 
Back
Top