Custome Counter - Return Counter Value

[Gary O]

I have followed the following kb item to create an incremental field

http://support.microsoft.com/default.aspx?scid=kb;en-us;210194

What I don't know is how to return the incremented number to my form.

I've tried:

[Form]![Comments]![WkOrderNo] = NextCounter

without sucess. Could someone please advise me how to do this?

Regards

Gary O

 

[Alex Dybenko]

Hi,
you can either set a default value property of WkOrderNo textbox to
=Next_Custom_Counter()
or you can use form's BeforeUpdate event to assing value:
me.WkOrderNo=Next_Custom_Counter()