combobox selection limited to textbox value

[mev2018]

Some help needed as I have been racking my brains all day.

I have a Form called: OyCards
I have the following controls on the form:

Textbox called: Team
Textbox called: Card Ref
Textbox called: Oysnum
Combobox called: Colleague

The controls on the form are from the table called: Oycards


The list of names in combobox: Colleague, has rowsource linked to a table called: staff

The table called staff has two columns in order:
teamresponsible
staffname


What I want to do, is for the combobox called Colleague in the form 'OyCards' to list only the names that are linked to the value in the textbox called Team.

i.e. Funding team will list 8 names out of the 100 that are in the table, and so on.

Any help on the code would be appreciated.

I tried using the source row and requery but it doesn't work.

Wayne

 

[xenou]

Hi, you can google for this topic as "MSAccess Cascading Comboboxes" or "MSAccess Dependent Comboboxes" - that should give you some tutorials.

I've followed this one before but others are equally good (strategies vary a little):
https://www.fontstuff.com/access/acctut10.htm