Display last entry on form

[SusanC]

Hi,
I need to display a field's last entry on a form so a user will know what the next entry needs to be.
I know how to creat subforms but I wondered if there was a simpler way to do this?
thanks
Sue

 

[Mile-O]

Is this "last entry" based on a sorted query as the RecordSource for your form?

 

[SusanC]

Hi,
no this last entry is from a table that is put in manually via a form.

Sue

 

[Mile-O]

Tables are basically unordered sets so the last record at one point may end up at the beginning or in the centre of the recordset at another time - chaos.

That's why it's best to use a sorted recordset (query) as the underlying recordsource for your form - you guarantee the records are in order.

Do you use an AutoNumber field or a DateEntered field?

 

[SusanC]

The field is on a table with autonumber but it isn't autonumbered itself...I hope that's what you meant.

 

[Mile-O]

Maybe the DMax() function (described in the help files) is what you'd want.

Failing that, the possibility of using RecordSetClones might be the way to go...how's your programming?

 

[SusanC]

I'll give the help files a go I think - my programming is very very basic!!
thanks
Sue