Forum Discussion

Jqws13_'s avatar
Jqws13_
Copper Contributor
Apr 18, 2022

Button from one form to another?

Hi All, Just wondering if there was an easy way to create a button, from one form (Form A), that would take me to another form (Form B), whilst opening a new record in Form B. I don't think it matters, but I have a relationship between the two tables that the forms are based upon.

1 Reply

  • arnel_gp's avatar
    arnel_gp
    Iron Contributor

    Jqws13_ 

    your form B, must be set to Data Entry = Yes (on design view).

    then Add Code to the Load event:

     

    private sub form_load()

    Me!FKeyFieldname = [Forms]![FormA]!PKFieldname

    end sub

Resources