Selections in Combobox A and B, then populate my choosen result in combobox C (with two columns)

[kacocal]

Hi Everyone,

I am quite new to MS Access and I am using MS Access 2007. I am going to build 3 comboboxes in a Form,

Combobox A is a drop-down box (it contains 3 values): Item 1, Item 2 and Item 3


Combobox B is another drop-down box (it contains 3 values): Data 1, Data 2 and Data 3
Combobox C is based on what you have choosen from Combobox A and B and it has two columns.

For example, I choose Item 1 in Combobox A and Data 1 in Combobox B, then Combobox C will have two columns and display Item 1 in column 1 and then
Data 1 in Column 2 of combobox C

Another example, when I choose Item 3 is combobox A and Data 2 in Combobox B, then Combobox C will have two columns and display Item 3 in Column 1 and then Data 2 in Column 2 of combobox C.

Are there any suggestions for me to achieve my goal? I am quite new to MS Access, but this had to be done by me a.s.a.p.

Any quick responses will be much appreciated.

Thanks.

[pbaldy]

Sounds like a homework assignment or something. If you have a one-record table, you can use a query but selecting each of the two combos and using that table so you only get one record.

[kacocal]

Sounds like a homework assignment or something. If you have a one-record table, you can use a query but selecting each of the two combos and using that table so you only get one record.

Hi Baldy,

Thank you for your reply. But what is best solution I can achieve my goal? How can I populate one record from combobox A into column 1 of combobox C and then one record from combobox B into column 2 of combobox C? Is it possible for me to write a query to achieve it? What will be my query looks like? (Both combobox A and B's values are the same table).

If anyone has any suggestions, please guide me through since I need to have the result a.s.a.p.

Thanks in advance.

[pbaldy]

Like I said:

SELECT Combo1, Combo2
FROM TableName

using valid full form syntax to refer to the combos.

[kacocal]

Like I said:

SELECT Combo1, Combo2
FROM TableName

using valid full form syntax to refer to the combos.

Thank you very much pbaldy. I have figured out how to do. Thank you once again.

[pbaldy]

No problem; I hope we get an "A".