store a new recordnumber

  • Thread starter Thread starter Toon_24
  • Start date Start date
T

Toon_24

How can I store the record ID in a textbox if i have just entert a new record

Thanks in advance
 
How can I store the record ID in a textbox if i have just entert a new record

Thanks in advance
Click to expand...

You'll need to post more of your context than that. ID for what? Is it an
Autonumber? Are you entering a record on a form, in a table, or what?
 
Hello John

I am storing a new recordset in a table and I want to store the record_ID
(autonumbering)
 
Hello John

I am storing a new recordset in a table and I want to store the record_ID
(autonumbering)
Click to expand...

Again... I'm maybe just dull today but I'm not understanding.

Where is this recordset coming from?
How are you "storing it in a table"?

If you run an Append query and append all the fields EXCEPT for the autonumber
field, Access will increment the autonumber and put it into the table - is
that what you mean?
 
Back
Top