If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access 97 Forms default behavior.
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 |
#2
|
|||
|
|||
Access 97 Forms default behavior.
|
#3
|
|||
|
|||
Access 97 Forms default behavior.
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 -- hth Al Campagna Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions wrote in message ups.com... 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 |
Thread Tools | |
Display Modes | |
|
|