How to get prevous record data?

[ylp]

Hi,

I have a continuous form with a textbox, which displays one month records' integer data, I need to get the current and previous record and see which one is bigger ?

I can get current one easily, but is there a easy way to get the previous one?
Thanks for help!

 

[vbaInet]

Are you talking about a field from the previous record?

 

[ylp]

Yes, a field from a record.

 

[vbaInet]

Is the Primary Key of the table a number?

 

[ylp]

yes, the pk is the autonumber.

 

[vbaInet]

1. Create a query that sorts the ID in DESC. It should also include the field you want to find
2. Use the DLookup function and for the domain use the query you created in 1
3. Set the WHERE argument of the DLookup to be, less than the current ID

 

[ylp]

thanks for your great help!

 

[vbaInet]

You're welcome.