Thanks Pat,
I am not sure why I would want to open this form to a specific record or how I would do that, but, I think you are suggesting that I place two buttons for this form on a switchboard. I don't have a switchboard for this DB yet (still in development) and I don't really want to clutter up my DB by having one form for entering data and another for editing it. I would still like to keep my users out of the table for editing as much as possible, so I need the form in case someone doesn't take the leave they planned on, or in case some aspect of the leave changes after it is entered into the DB.
I have not use MVB before, it is possible that I am not saving the code correctly. The procedure I have followed is this: Open my DB, open my form, press Alt + F11, double-click on "Form_Leaves", place curser at the bottom of the code window, click the drop-down box on the upper left of the code window and select "Form" (the drop-down in the upper right says "Load"), MVB inserts a line after the end of the previous section and the following:
Private Sub Form_Load()
End Sub
I then add the part sited above (DoCmd.GoToRecord , , acNewRec) and press the "save" icon in the toolbar.
I have tried closing and opening my DB, closing MVB, and, though the code stays in MVB the next time I open it, the form still opens to the first record.
Am I making a mistake in one of these steps?
This forum is super helpful, thanks for the responses.
Nick