Pop Form to open Navigation Subform in Add or Edit Mode

[djossh]

Popup Form to open Navigation Subform in Add or Edit Mode

Hi, I have a Navigation form and I have created a Popup form with "ADD" and "EDIT" button.. this will Popup after selecting the button from the Navigation Control... what I want is, when I Select the "ADD" Button I want my Subform in my Navigation form to set on Add Mode and Edit mode when I select the "EDIT" button.. please help.... I don't know how to link my Popup form button that will do what I wanted... Thanks..

 

[vbaInet]

This is an Access 2010 feature right? I don't have that version of Access so I may not be of much help here, but in the OpenForm event there's a parameter you can use to specify whether to open the form in Add or Edit mode. Or you can set the Data Entry property to True for Add mode.

I suspect the Navigation Form uses data macros.

 

[djossh]

This is an Access 2010 feature right? I don't have that version of Access so I may not be of much help here, but in the OpenForm event there's a parameter you can use to specify whether to open the form in Add or Edit mode. Or you can set the Data Entry property to True for Add mode.

I suspect the Navigation Form uses data macros.

Yes Im using Access 2010.. I tried that OpenForm event but my problem is linking it in my Popup form with ADD or EDIT button. I was thinking of a Macro or VBA code that will do the same. but I really don't know how to write codes..

I also tried the Macro builder that Guides me which form to open and what mode, ADD or EDIT... It works, but it will open a new window not on the Navigation Subform area..

 

[vbaInet]

Yes Im using Access 2010.. I tried that OpenForm event but my problem is linking it in my Popup form with ADD or EDIT button.

See this link:

http://baldyweb.com/wherecondition.htm