combo boxes for parameters

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

Guest

I created a form for a parameter query that should allow users to select each
parameter from combo boxes based on the appropriate table. I followed Martin
Green's guide at www.fontstuff.com/access/acctut08.htm, but I am yielding the
same drop down in both combo boxes.

The form is named "frmEstimateSelector".
In the first combo box, "cboProjectName", the Row Source is set to the table
"Project", which is where the field [ProjectName] exists.
In the second combo box, "cboBidNumber", the Row Source is set to the table
"Bid", which is where the field [BidNumber] exists.
The criteria in the parameter query is as follows:
In the [ProjectName] field: [Forms]![frmEstimateSelector]![cboProjectName]
In the [BidNumber] field: [Forms]![frmEstimateSelector]![cboBidNumber]

I get the "ProjectName" drop down in both combo boxes. I have tried
different objects in the Row Source property, but that takes it farther off
base. I feel as though the problem lies in the form "frmEstimateSelector"
properties, but I can't identify the problem. Any suggestions are greatly
appreciated!
 
Hi, Kevin.

Please post the Row Source, Bound Column, and Name properties of each combo
box, and I think I'll be able to help you.

Sprinks
 
Back
Top