Multiple tables into one form

[Accu-Grind]

I am trying to take two tables (one is customers and the other suppliers) and turn it into a form to pull up the data from the tables. I need to be able to enter new data. This is for a corrective action form so after pulling up the customer and supplier info, I need to input the problems and corrective action. This information will then be turned into a report that I can print out. I know this can be done because my boss has one that does our quoting.

Please give me directions. Thank you.

Kalyn

[ranman256]

1.
You could make 1 form, with a sub form and option buttons.
click option1 to load customers. Option 2 to load suppliers.
the AFTERUPDATE event would connect the table to the sub form and save form space.
(Or use combo boxes, or tabs)

2.
Tou can make 1 form with 2 sub forms, each connected to each table, but it makes it really cluttered on screen.

[Accu-Grind]

How do you make subforms? I don't see it in access 2007.

Forgive me, this is my first attempt to use this.