Not Saving Records

[H]

I have had a database on complaints, each complaint when logged is automatically assigned a number. The problem is i have created aform to log new complaints but if someone makes a mistake i dont want to delete the record i want to the information to go that they have entered but i dont want to lose the number. does that make sense i dont know if i have explained it to well.

please help i have been trying for weeks i dont know what to do

 

[Rich]

You have to use a custom autonumber Candace Tripp's website has an example.
HTH

 

[H]

i have got it on auto number, what happens is when you enter the form it comes up black so you can enter the information. as soon as any data is entered into one of the fields the record is automatically given a number, but if you find you have entered something wrong, or te record is all ready entered you can leave the form back to main menu but next record to be entered will give the next number and the other record has been deleted but there is a number missing. so i want to enter all the information and then only let if save by pressing a save button or something so the user can leave if there is a mistake and not have any missing records. can it be done?

 

[R. Hicks]

You will not be able to use an Autonumber to do what you want. An Autonumber is not designed to do anthing but to assign a unique value for record indentification. To do want you will need to change it to an Integer. Then you will need to use the DMax() function to retrieve the highest number stored in the field and simply add 1 to the returned value to make it the next sequential number.

HTH
RDH

[This message has been edited by R. Hicks (edited 09-03-2001).]

 

[H]

SORRY WHATS DMAX(), HOW DO I DO THIS, IT SEEMS LIKE IT WILL WORK BUT I AM LOST, PLEASE HELP..

THANK YOU

 

[R. Hicks]

DMax() is a Domain Aggregate function built into Access. You can find information on the usage of this function in Access Help files.

RDH

[This message has been edited by R. Hicks (edited 09-03-2001).]