Getting EOF Record information

[jossimon]

I am using a form to add a record to a table. I want to then retrieve the Primary Key, "Ticket Number," after the table has been updated. I am not up to par on Recordsets, but I am pretty sure I just need to get EOF of a recordset and select that field in a SQL String. How do I get the EOF Record in a recordset?

Thanks!

 

[alvechurchdata]

If it's a single-user system and you're using an AutoNumber field you could just Select Max(ID) to get the largest ID number.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[PaultheS]

I'm not sure exactly what you're trying to do.

Do you want to use the ticket number to do something directly after the record is created? Or do you want to go back and get it later?

What are you going to be doing with the ticket number?

 

[jossimon]

I am adding a record to a table. The primary id on the table is ticketno. I simply want a msgbox that says, "Ticket # _____ has been successfully created!"

I might be making this more difficult than it has to be.

 

[PHV]

Do a search on @@identity

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886