I have a bit of code (received grat

[aexley]

I have a bit of code (received gratefully from a tektips forum) that I want to sequentially increment an ID field.

If Me.NewRecord Then

...
...

If DMax("Contact ID", "Contact Information&quot = 0 Then
Me.[Contact ID] = 1
Else
Me.[Contact ID] = DMax("Contact ID", "Contact Information&quot + 1
End If

I have it activated on the OnLoad event - trouble is I'm getting a missing operator error but I don't know why. Also I can have more than 1 'Contact' per 'Site' but it doesn't activate when I move to a new record on my 'Contact' form.

Any ideas?

Thanks in advance.

aexley

 

[aexley]

P.S. Sorry about the unclear title - Monday morning fever I think.

:-/

aexley

 

[Craig0201]

Because it's in the wrong event???

Moving to a new record is the On_Current event, not On_Load.....

Craig

 

[aexley]

Bingo!

Perfect, thank you. The other error was just my sloppy typing.

Many thanks,

aexley