To whom it may concern:

I lost my code for making sequential numbers. Please resend the program example. I have a number that I want increased by 1 if a certain sequence exists.

For example, I have a field labeled "Certificate Number" I would like this to increase by 1 each time if the question in another field "Bearing Y/N" is labeled "Y".

So it would read something like if BearingYN = "Y" Then
{
??
}

I know this has been covered in the past, but I cannot find any examples.

Thank you,

Kevin E & S Gage