Forum Discussion

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 matter...

2016

access

arnel_gp

Iron Contributor

Apr 19, 2022

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