FORCE Next Primary Key Autonumber Generation

[Randomblink]

Ok...
I have a form based off of a table.
The table has a primary key called rpt_ID
The Primary key is an Autonumber.

While in a NEW Record, I need to grab the rpt_ID number...
However, since it is a BRAND NEW RECORD... the rpt_ID is not set yet? What can I do to get the rpt_ID WHILE in a NEW RECORD...?

Can anyone help me?
Thanks...

 

[Travis]

to make sure you are getting the next valid autonumber you will need to save the record. You can get the ID by adding code to the After_Insert Event of the Form.

 

[Randomblink]

THANKS!

THANK YOU SO MUCH!
Excellent!