Combobox #Name? Error

[AlexB123]

Hi all,

I have a combobox that is throwing the #Name ? error no matter what I do. There are two comboboxes on a single form, and the rowsource and control source are now set up similarly. One works, one throws the error.

I have removed a table from the database that the form property control source was set to ... is this the problem? Can I alter the form, or fix my properties?

Inside frmRegisterCreation, there are cmbClientID has ControlSource ClientID and RowSource SELECT tblRegisterClients.ClientID, tblRegisterClients.Client_Name FROM tblRegisterClients;

The other is cmbBOB with controlSource BOB and RowSource SELECT BOBID, BOB_Name FROM tblBOB;

Thanks for any suggestions.

 

[AlexB123]

Thanks so much for the explanations and responses. All have been very helpful.

Not sure where we're going with this. It seemed like the original problem was that you "broke" it by removing a table and either had to rebuild the form or put the table back. If what you're needing now is how to rebuild the form and whether or not to bind it or its controls, I'd say the scope of that subject is too involved for a forum thread, beyond general questions.

Yes, I agree the scope of my questions have reached their conclusion. After removing the table I ran in to these immediate questions, so thank you for your help!