Reset Form to Display First Record

[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

 

[Hugh O'Neill]

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

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

 

[John R. Youngman]

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

 

[Hugh O'Neill]

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

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

Hugh