I don't understand what you're asking. Do you mean like how you would have an invoice, and then have invoice details on that invoice? There could be multiple rows of parts from the parts table as part of the invoice? If so, try Invoicing.

Otherwise, can you explain more?

Ok, let me see if I can explain better.
I have a form in Access, I put combo boxes in a row that each pulls from a different table. For example, box 1 pulls from a number table 1-100. Box 2 pulls from a name table, and so on. That works fine, what I am trying to do is duplicate the boxes on another row but have a different value from the same table. for example, box 1a pulls from the number table but I can enter a different value from the number table 1-100. and in box 2a I can enter a different value from the name table. do I have to duplicate the table for each combo box?
I can't send pics, to show so, hope I can explain it well so it's understandable.

I don't know if this option is possible.

Thank you

OK, just to make sure I understand, When you say "row", do you mean like a new record from like a continuous form? Or is this all on one single form and it's just more combo boxes placed below the current ones?

I'm assuming if that's the case, it's the latter, in which case, you can have as many combo boxes as you want, as long as they have a unique control source. You can have NumberField1, NumberField2, NumberField3 in your table, and can have 3 seperate combo boxes that store 3 different numbers for that.

Another possibility, is you're actually trying to make a related subform kind of situation. Where for instance you have an invoice, then you can pick a part and price for that invoice, go to a new record (line) and add a second diffferent part/price, etc. In which case take a look at Invoicing

I have 2 Combo Boxes in a row. Row 1----->. Combo box 1 pulls from Table 1and Combo box 2 pulls from Table 2.
I want to have another row Row 2-----> with 2 more combo boxes, combo box 1a and combo box 2a, I want to pull data for combo box 1a from table 1 but be able to put a different value in combo box 1a, but have a different value from the table. it is one single form with more combo boxes.

How would I change the control source if I am pulling data for Combo boxes 1,1a,1b, etc, but need the data for these Combo Boxes, to all be from Table 1. That is what I am stuck on.



I am not trying to use a subform.