Writing different tabs to diff rows

[zabalme]

I need to know how to set up a form with three tabs, all of which having the same text boxes or method of data input. I want each tab to write the information input into different rows on my table corresponding to the tab (the tabs will correspond the the first column on the table). I have three rows on my table for three companies. I want a form that has a method of gathering the data for each company and writing that data to the corresponding row. I can set up the form with three tabs, all requesting the same info, but I don't know how to connect them to the corresponding rows.

 

[RuralGuy]

Are you suggesting editing three different records of a table at the same time? I imagine that could be done but it would take some interesting code and causes me to question either your table structure or your form.

 

[zabalme]

I am suggesting doing that. I'm not really sure the best approach. I am very new to Access so I am winging it with the Access 2000 Bible. If you recommend redoing the structure, I can no problem.

 

[RuralGuy]

Maybe you should describe the real world procedure you are trying to accomplish. Why are you dealing with three different companies at the same time? What relationship do they have with each other?

 

[zabalme]

I am comparing three different companies' capabilities in machining a product. Their capabilities depend on different dimensional and machining parameters. I want to get this info from them and go to a form, indicate which company I am dealing with, then proceed to input data. At the very end, I want a table displaying all the data relative to each company and possibly print it out in a report.

 

[ScottGem]

You are describing different things. Data entry is a part of your process. There is NO reason to lump it together. Even if you are getting the data from the 3 companies at the same time. All you need is a form where you select the company and either enter or update the data for that company.

The comparisons come later. if you want to compare the three companies' results you can create a query that will show each of the three companies. That can be displayed on a form or report.

 

[zabalme]

You are exactly right, but i don't know how to create this form. That is my question. I know how to go in and compare them.

 

[ScottGem]

Just use the Form Wizard to create the form. Its not clear whether you are adding new data or updating an existing record. I'd need to know to suggest anything more.

 

[zabalme]

I'm trying to input new data only.

 

[ScottGem]

Ok, then just create a form using the Wizard. After the Wizard does its work, go into Form Design mode and set the Data Entry property to Yes. This will restrict the form to only allw new entries.

Next, delete the control for the CompanyID and use the Combobox wizard to create a combo to select the companyID. If you select the company name using the wizard, it will set it up to display the name but store the ID.

 

[zabalme]

I think I am close, but when I try to input data, it won't let me. On the bottom, it says: "Cannot add record(s); join key of table 'SHD' not in recordset." SHD is the table that I want to write to.