G
Guest
I have a form , each record has an autonumber but also a number I gave it '
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick B
One post per question please.
http://www.mvps.org/access/netiquette.htm
PLEASE STOP POSTING YOUR QUESTION OVER AND OVER AND OVER. ONCE IS
SUFFICIENT.
http://www.mvps.org/access/netiquette.htm
PLEASE STOP POSTING YOUR QUESTION OVER AND OVER AND OVER. ONCE IS
SUFFICIENT.
N
Nick Coe \(UK\)
Check out the DMax() function in the help. You can
certainly use it in an expression in an update query and I
_think_ (but can't remember for sure) that you could use it
in the default value property of the appropriate control on
your form.
Something like =DMax("[SID]", "table or query name")+1
should automatically increment the SID field by 1 each time
a new record is added and the user doesn't have to do it
(and probably shouldn't).
HTH
--
Nick Coe (UK)
http://www.alphacos.co.uk/ AccHelp is now Free
http://www.mrcomputersltd.com/ Repairs Upgrades
In martyn typed:
certainly use it in an expression in an update query and I
_think_ (but can't remember for sure) that you could use it
in the default value property of the appropriate control on
your form.
Something like =DMax("[SID]", "table or query name")+1
should automatically increment the SID field by 1 each time
a new record is added and the user doesn't have to do it
(and probably shouldn't).
HTH
--
Nick Coe (UK)
http://www.alphacos.co.uk/ AccHelp is now Free
http://www.mrcomputersltd.com/ Repairs Upgrades
In martyn typed: