PopUp form to run Other forms

[djossh]

Hi, I have a Navigation from.. I want to have a popup form with "Add" & "Edit" button that will do the same.

Here's the Scenario.

On Navigation form

Click the Control to open a form (Employee)... then "PopUp" form will appear, then if I select the "Add" button.. i want my form in the Navigation to go to new record... but if I select the "Edit" button.. I want my form in Navigation to open in Edit mode...Please help....I dont know how to do this..any sample would be helpful....Thanks

 

[vbaInet]

There are a couple of ways. I'll give you one.

Add:
1. Set focus to the form (i.e. DoCmd.SelectObject acForm, "FormName")
2. DoCmd.RunCommand acCmdRecordsGoToNew

Edit:
1. Set focus to the form
2. Edit the record. Look into one of the constants of DoCmd.RunCommand for the edit constant.

 

[djossh]

There are a couple of ways. I'll give you one.

Add:
1. Set focus to the form (i.e. DoCmd.SelectObject acForm, "FormName")
2. DoCmd.RunCommand acCmdRecordsGoToNew

Edit:
1. Set focus to the form
2. Edit the record. Look into one of the constants of DoCmd.RunCommand for the edit constant.

Thanks.. But how do i linked this to my button?

 

[vbaInet]

In the ON CLICK event of the button.