Using a form to add data to another form

[Johnthelleader]

I have created a form in order to add data to an existing form. It has the same fields. It is just formatted slightly differently to make data entry easier. So ideally on the existing form I push a button saying "add new company", it opens up the new form with blank fields, data is then entered and on close or it has a button on save and close, updates the information to the existing form. Is this possible?

Look forward to anybody's help.

 

[ansentry]

Use the Wizard.

Using the wizard put a command button on your "First" form and then from the list select:
1> Form Operation /Open Form (NEXT)
2> Select Name of form you wish to open.(NEXT)
3> Select first option ( Open the form and find specific data to display) (NEXT)
4> Select what you want to link by ( Selct you primary key field, most likely an auto number) (NEXT)
5> The rest is just follow the prompts.