A New Form

[Staelens30]

I am trying to make a new form but cannot think of how to set it up to bring in the other tables so that everything will enter into the right tables I still have not made command buttons to open the other forms yet this is a work in progress that is taking me a very long time to accomplish i kind of have a mental block at the moment. attached is my current DB if anyone has any ideas.View attachment Josh1.mdb

 

[Poppa Smurf]

I am trying to make a new form but cannot think of how to set it up to bring in the other tables so that everything will enter into the right tables

PLease list what you want on the form and the function of the form. The form can not be created unless you know the requirements.

 

[boblarson]

Okay, I have something for you.

Also, you needed to have DealID in the FrmDealInfo form's recordset. So I added that field by simply removing all of the fields in the select statement and adding the whole table by use of the Asterisk (*) in the underlying recordset of that form.

And, your Customer table didn't have the right Primary Key. I reset it to an autonumber (you can still enter a customer number that is based on the agency's numbering scheme if you want but the key should be an autonumber) and on the form it should not be a value list in a combo box.

So, I fixed up your form with the subforms so you can see how it goes. You can format it all to your liking.

Sorry for taking so long. I was extremely busy yesterday and this requires a bit of time to deal with.