Skippymouse
New member
- Local time
- Today, 22:19
- Joined
- Jan 5, 2001
- Messages
- 8
I know I should not be having a problem with this, but......
I have a combo box on a form wherein the user selects a Provider (based on a Provider table). I also have a Location combo box (based on a related Location table). Each Provider may have several locations. The client would like me to restrict the choices in the Location combo box to only those directly linked to a given Provider when that Provider is selected. I have tried running the Location combo box through a query, which (theorectically) produces a list of Locations based on the Provider name in [Forms]![Form].[ProviderName]. The query does not produce any results even though I have correctly addressed the field. I have used a similar technique, but that involved a subform which was based on the query itself.
I am absolutely certain I am making a very simple mistake, but my mind went to Jamaica without me and I am having to make do. Any help on this dilema would be very much appreciated.
I have a combo box on a form wherein the user selects a Provider (based on a Provider table). I also have a Location combo box (based on a related Location table). Each Provider may have several locations. The client would like me to restrict the choices in the Location combo box to only those directly linked to a given Provider when that Provider is selected. I have tried running the Location combo box through a query, which (theorectically) produces a list of Locations based on the Provider name in [Forms]![Form].[ProviderName]. The query does not produce any results even though I have correctly addressed the field. I have used a similar technique, but that involved a subform which was based on the query itself.
I am absolutely certain I am making a very simple mistake, but my mind went to Jamaica without me and I am having to make do. Any help on this dilema would be very much appreciated.