Combo Box

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

Guest

I'm trying to allow users to enter new contacts into our database. Ideally
I'd like them to be able to either enter a new company or choose from an
existing company. We're dealing with foreign suppliers so we may get several
with different spelling variations if they can't choose from an existing
supplier.

I made that entry field a combo box and have it query values from a table
the data is not being put into. It gives me an error "the value you entered
isn't valid for this field" when i click on the combo box tab. It then shows
the list of all companies.

How do I get rid of the message? And any good thoughts on how to deal with
an unlisted supplier smartly? It's my first database build from scratch, so
I'm sure these are basic questions. Thanks in advance.
 
Hi Mathew

Sounds like maybe your bound column is not set right on the form. Most
combos (that I use) have the bound column set to the first column - like
1;1;1;2;3;etc with the first column being the ID or autonumber and the other
"stuff" in the rest.

If you are displaying the new contact "name" in the combo then it may be
that you have not set the property to the column ( like 0;1;1;2;3;etc) - -
assuming the the Text is in column 1 - that's the 2nd column then you are
trying to enter text in a number field.

Try changing the bound column to the one that contains the new contact name.

Give it a try and see what happens. Hope it works.
 
Sorry just read your thread again - ooops.

If it's an "unlisted" supplier and your referential integrity is set set
then you won't be able to load the new contact as you can't have a new
supplied (child record) without a coresponding field in the main table
(parent) . Remove the ref integ from the join and see if that works.
 
Back
Top