I have a database i use to file. when i insert a new record i want it to imediately insert the next value (file number).the problem is the value is acording to subject. eg
Subject1 has a record with a maxvalue of 5.
Subject 2 also Subject2 has a record with a maxvalue of 5
subject 3 may have a a record with a maxvalue of 6 etc.
thus it has to insert the next higest value according to subject.
I tried to do this by making a subform which had a record source updated by a combobox with the subject the subform had a txtbox which showed the highest value. The datafeild then took this value from the subform and added 1 to it.
This did not work any suggestions?
Tnx for any help
Tell me if im not clear on what my problem is and ill try explaining again.