Combo box NAME# error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I had created a form with combo boxes. Then I had the bright idea to
alphabetize the entries by changing the properties of the form and now the
combo box displays NAME#. I realize that this has something to do with the
Control Source but it remains in the underlying table for the form...what did
I do?
 
Execute the actual query that populates the combobox. Chances are you have an
error in it.
 
Does the field name from the table/query appear in the field list?

If you are not using a query to pull data from the table then you need to
review the SQL statement used as Row Source. It has to have a field named
the same as the Control Source.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo Box Problem 5
Making all controls match selection of combo box 0
Combo Box, Unbound Text Boxes 2
OnClick on Combo Box opens a New Form 0
Combo Box Selections 1
cant get cbo to stop outputting key# 0
Combo Box Selection is Blank 1
Combo Box that fills Text Box in form 4

Back
Top