Auto number forms

[Guest]

I'm using =DMax("[Note_Number]","Notes")+1 statement in a form field and it
works fine. My problem is that in my table each note has a customer column in
the table. I need the Note_number to increment but be filtered with the
customer column exp: Customer 1 Note 1,2,3,ect.; Customer 2 Note 1,2,3,4

I hope this makes sense

Thanks,

Rick

 

[Rick Brandt]

I'm using =DMax("[Note_Number]","Notes")+1 statement in a form field
and it works fine. My problem is that in my table each note has a
customer column in the table. I need the Note_number to increment but
be filtered with the customer column exp: Customer 1 Note
1,2,3,ect.; Customer 2 Note 1,2,3,4

I hope this makes sense

=Nz(DMax("[Note_Number]","Notes", "[Customer] = " & Me!Customer),0)+1

The Nz() is for the first record that a particular customer has. If the
Customer field is text then you need quotes like...

=Nz(DMax("[Note_Number]","Notes", "[Customer] = '" & Me!Customer & "'"),0)+1