Current Record on a Form

[rs2004]

How do you show the current record on a form? So you dont have to show the record selecters on a subform.

 

[Ashfaque]

As I know you may show the current record on the form only :

1. If you are storing date /time in table for the record, you may set the date/time field to descending order in soruce query or table of your form enable to keep current record on the form.

2. OR if the autonumber / Number field (that set to No Duplicates) of your table has set to desceding order which will show always last record on the form whenever you open it.

Regards,
Ashfaque