ComboBox and form

[Zelo]

Hallo.
I need Help. I have two tables Contacts and Orders. And have a Form with data from table Orders and one One ComboBox with data from Contacts. So, when i chhose in combobox for example contact name, i need to see all indormation about this contact from table Orders. How to make this?

 

[antoka05]

You need to change the RowSource properties (presents in Data tab) of the second combobox.

Then, in the code of the first combobox, put the instruction:

Combobox2.Requery

I've attached a sample hoping it can help.

Regards,
Antonio