Automatically Sequencing Subform Entries.

[zachsiue]

Hi,

I have a form that utilizes several subforms. On the main form, the user will enter the Event and the EventName. This will then bring up all of the SEQUENCED items in the subform. If creating a new record in the subform, the user must enter a value for SequenceNumber. (The sequence number is one of the keys used in other subforms). I was wondering if there was a way for me to design the subform so that the new entries are sequenced automatically. Auto number will not work, because I need the SequenceNumber to start back at 1 for each different event. Right now I am having to go throught the process of looking at the navigation buttons and entering the associated record number into the SequenceNumber blank. Is there a way that I could link my SequenceNumber control to the record navigation button number? If not is there a better way to do this than brute force?

Thanks a ton!!!

Zach

 

[jsaliers]

just to throw out an idea, but not sure if it will work...

For each new event, if you want to start at 1 and sequence from there, use a counter, reset it to 1 on a new event, and use the count value to enter in for the SequenceNumber.

Hope this helps.

Jon