With help from others on this board (thanks!) I have created a combo (1) whose RowSource is based on a query that uses the contents of another combo (2).
It works when you open the form (combo 2 has a default value), but does not work if another combo 2 value is selected by the User. It continues to work on the initial value set in combo 2.
Do I have to refresh something to tell combo 1 to go and look at the current value of combo 2?
Dave
It works when you open the form (combo 2 has a default value), but does not work if another combo 2 value is selected by the User. It continues to work on the initial value set in combo 2.
Do I have to refresh something to tell combo 1 to go and look at the current value of combo 2?
Dave