Combo box doesn't relate correctly to another combo box

[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.

 

[Kelvin]

Forms should not be in brackets.

Forms!tblPerson!cboPlanNameSelect

Kelvin

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.

 

[Guest]

Thanks.