Open Form in add mode (1 Viewer)

[Cosmos75]

What code opens a form in add mode?

I have a form (paint) with a subform (constituents).

The subform has a button to open up a table that contains constituents. I want to have two buttons

- one to open up the constituents form in add mode so that the user can add a new constituent
- one to open constituents form so I can edit the current selected constituent [I/(I think Microsoft's Knowledge Base has an article on this?)[/I]

 

[Travis]

Add
DoCmd.OpenForm frmName, acNormal, , , acFormAdd

Edit
DoCmd.OpenForm frmName, acNormal, , , acFormEdit

 

[David R]

Don't forget the WHERE clause in the second example.

Check the Access Help file 'Synchronize records between two forms' to see what I mean.