Hi All,
I have a combo box that looks up values in a tbl.
Is there a way in the combo box control that I can change which values it shows for different FE users? But without having different queries to designate the criteria? I thought I could just use a query and control the combo box with that query, but when I do that then it throws up issues with other controls I have on the form that has a control source being the main tbl.
Any ideas?
I have a combo box that looks up values in a tbl.
Is there a way in the combo box control that I can change which values it shows for different FE users? But without having different queries to designate the criteria? I thought I could just use a query and control the combo box with that query, but when I do that then it throws up issues with other controls I have on the form that has a control source being the main tbl.
Any ideas?