Query

[Guest]

I have a form that has a combo box on it. The combo box selects a
developer's name from a table named tbl-developer. I'm trying to pass off
that name into the criteria of a query to filter only the projects of that
developer. The form's name is frmByDeveloper and the field's name is
DeveloperName. I put the following in the criteria of the DeveloperName in
the query =[tbl-Developer].[tbl-Developer].DeveloperName] and some other
variationss but it ask me to enter parameter value. Can someone help me??

Thanks
Wm.

 

[Guest]

Did you try

Forms![MainFormName]![ComboName]

 

[Guest]

Sorry, I changed the code, the query opens but does not show any data but the
developer comes from a drop-down so there must be projects for that
developer. What is the magic of this stuff?? I only have 15 minutes of
experience but....

Did you try

Forms![MainFormName]![ComboName]

--
\\// Live Long and Prosper \\//
BS"D

I have a form that has a combo box on it. The combo box selects a
developer's name from a table named tbl-developer. I'm trying to pass off
that name into the criteria of a query to filter only the projects of that
developer. The form's name is frmByDeveloper and the field's name is
DeveloperName. I put the following in the criteria of the DeveloperName in
the query =[tbl-Developer].[tbl-Developer].DeveloperName] and some other
variationss but it ask me to enter parameter value. Can someone help me??

Thanks
Wm.