Using bound form to access last record

[ismith]

Hi,

Ive got a bound form which has the following info.



These are all in a table called 'tblProduct'

ProductID
Description
Category
Size
Quantity
Price

Now when i use the bound form it shows the first record in the database.
What i want to do is whenever the form is opened it goes to the last ProductID record that has been entered into the database. so it is always the last one that is showing.

Can this be done using bound forms?

If not how else can i get this done?

Thanks...

[aytee111]

OnOpen event - Me.MoveLast

Or in your RecordSource sort it by ProductID DESC (descending)