Dependant Combo Box w/ Default Value Question

[smille777]

Hi everybody.

I don't know exactly how to clearly explain this, but I will give it a shot.

I have a form "Customer Quotes" which has a [CustomerID] field where the default value

=[Forms]![Quotes by Customer]![CustomerID]

On the Subform "Customer Quote Details" I have a combo box:
cboProductID.

My issue is this: I have another table "Customer Requirements" that I want as my recored source for [ProductID] and yet have it dependant on the default value for [CustomerID] in "Customer Quotes" Form.

I hope this makes sense. I am a bit confused myself. ANY help is GREATLY appreciated.

Scott

 

[HaroldGE]

Something like this ...

cboProductID.RecordSource="Select field1,field2 " & _
  " From tableofCustomerRequirements Where CustomerID=" & _
  [Forms]![Quotes by Customer]![CustomerID]

Play around with a select query first and you'll get a better idea what this should look like ( use SQL View ).