Open a form from another form

[kmclane]

I have two tables, I have two forms. I can add data to each no problem. I want a user to be able to click a button on the first for which should open the second form, populate a couple of matching fields, and let them add one or more records to the second table. I can't even get the second form to open. I tried to do it in a module, but it keeps giving me a syntax error. this is what I have so far:

DoCmd.OpenForm("Principals",acNormal,,,acFormAdd,acWindowNormal)

Which should open my second form. Or so I thought, any suggestions will be appreciated.

Ken

 

[anvil19]

Hi Ken

Remove the brackets from

DoCmd.OpenForm("Principals",acNormal,,,acFormAdd,acWindowNormal)

, like so

DoCmd.OpenForm "Principals",acNormal,,,acFormAdd,acWindowNormal

In fact, with the arguments you are choosing, you just need this:

DoCmd.OpenForm "Principals",,,,acFormAdd

The acNormal and acWindowNormal are the default constants for the OpenForm method.

anvil19

 

[kmclane]

Thanks! I'll have more questions later.
Ken