Help with RECORDSET Function

[Leaner79]

Hi. I'd like help with recordset.

I have a form that i use to capture data. When i click a button I would like to have a message box to be displayed, showing the last record i entered in a particullar field.

 

[PHV]

Have a look at RecordsetClone and MoveLast

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

 

[Golom]

Need a better definition. Relational databases don't have any predefined ordering of rows so the definition of the "last" row is uncertain. Your rows in the table will need some field or combination of fields that can be used to determine which one is the last one.

Do you have such a field or fields?

[small]On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question. (Charles Babbage)[/small]