linked combo box is empty

[hlkelly]

I have an order form and cboContacts is empty after making a selection in cboCustomer. I am using the following code to link from cboCustomer:

SELECT contacts.contactid, contacts.contactname FROM contacts WHERE (((contacts.customerid)=forms!tblorders!cbocustomer)) ORDER BY contacts.contactname;

I have already entered form_current code: me.cbocontacts.enabled=false

cboCustomer_afterUpdate:
me.cbocontacts.enabled = true
me.cbocontacts.requery

Thanks for your help! Heather

 

[cas20002000]

Try something like this:

cboCustomer_Change()

me.cbocontacts.RowSource="SELECT contacts.contactid, contacts.contactname FROM contacts WHERE (((contacts.customerid)=" & forms!tblorders!cbocustomer & &quot) ORDER BY contacts.contactname"

me.cbocontacts.Requery

This should work, if not,
I hope you get the idea of what I'm trying to say.

Sorry for the bad grammar.
Regards,
Carlos.