Filtering dropdown by value in another cell

[Bankaifan]

Hello together,



i am totaly new to access and have a little problem.
(sorry for my bad english )

I have a few tables. One of it is a matching table between a table with people information and a table with event information.
now it want to do something like that:

the first column is filled with the event name (refence to the event table is done so i can choose from the drop down list)
the second column should contain the company name of the persons who visited that event. (also done)
the third column now should contain the visitor name. but the drop down should be filter so that only the people working for the company choosen in column two selected.

in my visitorstable the company of the peoples is referenced so i have to check, when the drop down opens, is the company written in column two also found in the column in my visitors table.

i hope you understand what i want to do and you can help me solving this problem.

Best regards

Daniel

[ItsMe]

If you want your combobox to include only the records that are associated with a textbox you need to adjust the combobox's "RowSource" to include the current value of the textbox.