Combo Box-Not able to make selections (2000)

[masterd]

Hi,
What would cause a combo box to only allow the first item in the list to be selected. The combo box is on an unbound form. The form has 2 combo boxes. The first one is updating ok, it let's me make multiple selections from it's list and it is based on a query. The 2nd combo box is also based on a query with criteria that makes it only show a list of items based on the first combo box ([Forms]![frmSearchForm]![cboSearchFormDPLLookup]). When I try to make a selection it doesn't matter what I click on it only gives me the first item in the list. I've done this several times before but with bound forms and I can't figure out what I'm doing wrong.
Thanks,
Deb

[HansV]

Is the Locked property of the combo box set to Yes?

[masterd]

Hi Hans,
It's set to No, and when I click on the drop down menu, it says calculating in the lower left corner.
Thanks,
Deb

[HansV]

I dn't think we can help without seeing the database.

[masterd]

Hans,
I've attached a scaled version. It's the only form - frmSearchForm.
Thanks,
Deb

[HansV]

You have made lngMachineID the bound column of the second combo box, but this is the same for ALL items, namely the lngMachineID selected in the first combo box. You must make lngPartID the first column in the row source of the second combo box:

SELECT qrySearchFormPartsLookup.lngPartsID, qrySearchFormPartsLookup.txtPartNomen, qrySearchFormPartsLookup.txtTechManPartNo, qrySearchFormPartsLookup.intQty, qrySearchFormPartsLookup.lngMachineID FROM qrySearchFormPartsLookup WHERE (((qrySearchFormPartsLookup.lngMachineID)=Forms!fr mSearchForm!cboSearchFormDPLLookup));

[masterd]

Thanks Hans,
That did it. Lost a few hairs on that one.
<img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
Thanks,
Deb