control + apostrophe

[siggy]

control + apostrophe will bring up the previous record's value...

I require it to be the previous value PLUS ONE....
if the previous value was 1357 ( numeric), I need field in new
record to be : 1358 ( yet still allow it to be changed..... )

and therefore, if I now enter a value of : 7531,
then the NEXT new record would default to : 7532


siggy

 

[Steve Schapel]

Siggy,

You can't do this with the keyboard shortcut. There would be a way to
do this with an AutoKeys macro, by defining your own keystroke
combination to enter this value. But this may work for you instead...
Just set the Default Value property of the textbox on your form to the
equivalent of this...
DMax("[TheNumberField]","YourTable")+1

Will that do what you want?

 

[siggy]

perfect -- thanks

Siggy,

You can't do this with the keyboard shortcut. There would be a way to do
this with an AutoKeys macro, by defining your own keystroke combination to
enter this value. But this may work for you instead... Just set the
Default Value property of the textbox on your form to the equivalent of
this...
DMax("[TheNumberField]","YourTable")+1

Will that do what you want?

--
Steve Schapel, Microsoft Access MVP

control + apostrophe will bring up the previous record's value...

I require it to be the previous value PLUS ONE....
if the previous value was 1357 ( numeric), I need field in new
record to be : 1358 ( yet still allow it to be changed..... )

and therefore, if I now enter a value of : 7531,
then the NEXT new record would default to : 7532


siggy