Clarification on Problems with DMax +1

[Tina]

Where did you place the code outlined below??? Under the
form or under a specific control.

HI Tina!
I've just tried the Dmax +1 and it works ok..
Here my code:

dim res as Long
res = DMax("ClientNo", "clients") + 1
In your case it would look soemthing like this:
res = DMax("System_ID", "NameOfYourTable") + 1

I hope that you wish to add +1 to the Max found in the
column 'System_ID'. If this is the case then
replace 'NameOfYourTable' by the name of the table
which 'System_ID ' is a part of and that sould do the
trick..
The 'res' should then be used as the new 'System_ID'
number for that new user/client.

hope this helps,
PAtrick

 

[Patrick]

In this example I put-it in the Click event of a button,it
depends where you want to have this append..

PAtrick