Reset Form to Display First Record

  • Thread starter Thread starter John R. Youngman
  • Start date Start date
J

John R. Youngman

Hi. I'd like to add a command button on a form to reset the display back to
the first record.

Any ideas?

TIA

John
 
John said:
Hi. I'd like to add a command button on a form to reset the display
back to the first record.

Any ideas?

TIA

John
Click to expand...


That depends on what you mean by 'first record'. In a relational
database such as Access, records are just piled into a bucket in no
particular order. You set and change the order through use of Queries
etc. Do you have a field (such as a time-stamp) that can be used to
determine which was your 'first' record?

hth

Hugh
 
Thanks, Hugh.

I wound up using the following:

DoCmd.RunCommand acCmdRecordsGoToFirst

This returns me to the first record in my query (simply based on a member
number field, so it starts with member #1)

John
 
John said:
Thanks, Hugh.

I wound up using the following:

DoCmd.RunCommand acCmdRecordsGoToFirst

This returns me to the first record in my query (simply based on a
member number field, so it starts with member #1)

John
Click to expand...


OK, so long as you realise that may not always give you the same record
as being the 'first' one.

Hugh
 
Back
Top