ADD one number .

[uknow]

Hi,

Anyone there knows any function or formula to increase one each time the field is enter.For instance, if the feild has a No 1, then each enter will add ! to become 2.

appreciate for your help.

chhers.

 

[SgtJarrow]

If you which to increment the field every time you enter it, the you could use:

The OnEnter Event for the field put the following code:

Me![Name of Field] = Me![Name of Field] + 1

****************************
Only two things are infinite, the universe and human stupidity, and I'm not sure about the former. (Albert Einstein)

Robert L. Johnson III
MCSA, CNA, MCP, Network+, A+
w: robert.l.johnson.iii@citigroup.com
h: wildmage@tampabay.rr.com

 

[uknow]

thanks.