Combo box doesn't relate correctly to another combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the following query in a combo box cboPlanVersionSelect that should display versions for a person selected in another combo box, cboPlanNameSelect

SELECT DISTINCT [tblPerformance].[Version] FROM tblPerformance WHERE ((([tblPerformance].[Version]) Is Not Null) And (([tblPerformance].[NameFull])=[Forms]!tblPerson!cboPlanNameSelect));

When I click in cboPlanVersionSelect, it brings up a window, "Enter Parameter Value" for FormstblPersoncboPlanNameSelect.

Everything looks to be spelled correctly. What connection is missing, and how do I fix it.
 
Forms should not be in brackets.

Forms!tblPerson!cboPlanNameSelect

Kelvin

DesertBear said:
I have the following query in a combo box cboPlanVersionSelect that should
Click to expand...
display versions for a person selected in another combo box,
cboPlanNameSelect
SELECT DISTINCT [tblPerformance].[Version] FROM tblPerformance WHERE
Click to expand...
((([tblPerformance].[Version]) Is Not Null) And
(([tblPerformance].[NameFull])=[Forms]!tblPerson!cboPlanNameSelect));
When I click in cboPlanVersionSelect, it brings up a window, "Enter
Click to expand...
Parameter Value" for FormstblPersoncboPlanNameSelect.
Everything looks to be spelled correctly. What connection is missing, and
Click to expand...
how do I fix it.
 
Back
Top