Just like a form and a subform are linked by a tables that have a relationship, I want to have two separate forms that are linked by two tables that have a one to one relationship. I have a button on the first form that when clicked will bring up the second form. I would like the fields on the second form to populate automatically based the common field. Does this make any sense?
If you use the wizard to create the command button that brings up the second form it usually gives you an option to "open up form and find specific data to display" Did you see this?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.