Select Statement Revision Needed to Reflect Change

[davesaint]

I have a form in my DB that contains 3 combo boxes with Select Statements in them (cboContract, cboCAM, cboWP)The data is pulled from the the table WPData. The last statement pulls in a ID number into the form. I would like this statement to be revised to pull in the ID and it's matching Descrption Name. This Desciprtion field name is called Desc in the WPData table. Can this be done? If so, how should the select statement revised to reflect this. If this is not feasible would it be better to create a join query to merge the two fields together?

Combo Box (cboControact)
SELECT DISTINCT WPData.Contract FROM WPData;

Combo Box(cboCAM)
SELECT DISTINCT WPData.CAM, WPData.Contract FROM WPData WHERE (((WPData.Contract)=Forms!SelectForm!cboContract));

Combo Box(cboWP)
SELECT WPData.SourceAct, WPData.Contract FROM WPData WHERE (((WPData.CAM) Like (Forms!SelectForm!cboCAM)) And ((WPData.Contract) Like (Forms!SelectForm!cboContract))) ORDER BY WPData.SourceAct;

 

[Crowley16]

change the columnCount property on the combobox...?

--------------------
Procrastinate Now!

 

[davesaint]

Crowley16

Thanks! Worked perfect!