Access 97 Forms default behavior.

[techjohnny]

Hello, Group:

I created a form to input data into a table, very simple form, and I'd
need to change the default view when the user opens the form.
Currently, the form opens up to the first record created, but I'd like
the form to open up to the next available records.

Thanks,

--TJ

 

[fredg]

Hello, Group:

I created a form to input data into a table, very simple form, and I'd
need to change the default view when the user opens the form.
Currently, the form opens up to the first record created, but I'd like
the form to open up to the next available records.

Thanks,

--TJ

What does 'next available records' mean to you?
The 2nd record? The last record? A new record?

 

[Al Campagna]

TJ,
If you mean you'd like to open the recordset on the form to a New record...
and, you didn't indicate how you were open ing the form (from a button Click, or just
Dbl-Clicking the form from the Access (database) screen.
From Button:
Add a GOTORecord command after the button OnClick Open command.
DoCmd.OpenForm "YourForm"
DoCmd.GoToRecord , , acNewRec
From Database screen:
Use the OnOpen event of the form to...
DoCmd.GoToRecord , , acNewRec