Query

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

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.
 
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....
Ofer said:
Did you try

Forms![MainFormName]![ComboName]

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


open a adobe file from a command button said:
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.
 
Back
Top