autofill

[Mile-O]

Couple of removals - don't need the boolean variable anymore...

 

[BoroLee]

Thank you for your help.

That works great now.

 

[Mile-O]

No probs!

 

[BoroLee]

Mile, Can u help???

The person entering the data has just informed me that they have reached the 10th perosn whose name beings with W. That works OK.

However, when they enter an 11th, it still gives W10 as a refernce.

Any idea's????

Thanks,

 

[Mile-O]

In the query, change the expression for the Code field to:

Code: CLng(Mid([CardID],2))

rather than

Code: Mid([CardID],2)

 

[BoroLee]

Thanks again