none
value from navigation subform which is not active RRS feed

  • Question

  • Hi ,

    my navigation form has two navigation pages.

    form for second page is determined by certain condition by vba at onload event.

    i want value of a control in second page form in first page form. 

    is it possible/

    i think a way to get it, on onload event when second form is set for second page, activate the second page, get the value in variable and then activate the first page, take the value in first page.

    but i dont know how to activate a navigation form through vba.

    please help

    Friday, June 10, 2016 4:26 PM

Answers

  • >>>but i dont know how to activate a navigation form through vba.

    According to your description, you could use BrowseTo to navigate from form1 to form2 without opening up a new window:
    DoCmd.BrowseTo ObjectType:=acBrowseToForm, _
        ObjectName:="FormName", _
        PathToSubformControl:="Navigation Form.NavigationSubform"
    For more information, click here to refer about DoCmd.BrowseTo Method (Access)

    • Proposed as answer by David_JunFeng Sunday, June 19, 2016 2:40 PM
    • Marked as answer by David_JunFeng Monday, June 20, 2016 2:34 PM
    Monday, June 13, 2016 6:34 AM