Opening a form in different mode 1

[ZmrAbdulla]

Hi,
I wish to open a form two different mode.
Idea is that, When I click a button called "Edit" the form should open displaying the same record that I am currently viewing. This can be done through the wizards setup.
But When I click button called "Add New Record" the from should open in a new record mode.

How can I create this?

Thanks in Advance.
ZmrAbdulla

 

[Egglar]

In the "Add" buttons on click event, this VB code will open the form in add mode:

'Call DoCmd.OpenForm("frmPurchaseInvoice", acNormal, , , acFormAdd)

This will open it in edit mode:
Call DoCmd.OpenForm("frmPurchaseInvoice", acNormal, , , acFormEdit)

If you play with these statments you can also set a filter, so you could get it to open up an existing record to edit.

Hope this helps.

 

[Egglar]

Sorry forgot to change, "frmPurchaseInvoice" was the name of the form i was using to test the command, you should put the name of the form you want to open up instead.

 

[ZmrAbdulla]

Hi, Egglar,

Thanks it is working great
ZmrAbdulla