Create New Record

[bwyrwitzke]

Create New Record - Strange

How do I create a new record on FORM2 when I'm working with FORM1?

Here's the breakdown. I have a dialog box (FORM1) that contains a list box where users can make selections and a 2nd form (FORM2) opens up with the record details. I'd like to put a cmd button on the dialog box form that the user can click that will open up FORM2 with a blank record. I keep getting errors in the code. Any help would be appreciated. Thanks in advance.

Bruce

Update: I set a global variable that FORM2 can check. It almost works. The strange part is that it opens the 6th record instead of a new record.

 

[bwyrwitzke]

Got it to work. Was using the wrong command. The code should look like this:

DoCmd.OpenForm stDocName, , , acFormAdd

Thanks again to all of you for making this board so helpful!

Bruce