I have a main form (1 reservation header) and a subform (with many reservation details). As I know the reservation header info I fill out the fields and hence the user can move immediately to the subform and add the reservation details and only change the header if necessary. The problem I have, is how to force a new record at the Load event of the main form. Nothing I have tried so far worked. Even if i try to fill some dummy data in one of fields of the main form and the erase it again - it does not create a new record. If I use lostfocus at the first field Access dies (not sure why). However, the form works fine if the user manually changes any of the main form data. Any help is greatly appreciated! Thanks Michael
docmd.OpenForm "formname", , , , acFormAdd
it should open the form to a new record, but you might also check to make sure that the forms AllowAdditions property is set to Yes.
Are you displaying the navigation buttons on the main reservation form? If so, you should be able to click the "new record" button in the navigation bar.
Dale