store a new recordnumber

[Toon_24]

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

Thanks in advance

 

[John W. Vinson]

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

Thanks in advance

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?

 

[Toon_24]

Hello John

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

 

[John W. Vinson]

Hello John

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

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?

 

[Toon_24]

Hello John,

I have found an other way to solve my problem, thanks anyway

Toon