Not "Limit to List" Combo Box.

[Rich D]

I have a Combo box which limits me to the names on the list. I want to be
able to put in my own name (not on the list). It says I can't. So I went to
properties and changed the "limit to list" to NO. Then it tells me to change
the "Column Widths" because the first visible column is not equal to the
bound column. I go to Column Widths property and it says: 0";1.698". I
delete the 0"; When I go back to Limit to List it says NO. Great! Then when
I open the Form, I get a parameter box that says "lookup_combo42,VendorName".
I click OK, it goes into the form but instead of displaying the Vendor Name,
it shows the ID # 10, whichcorresponds to the right Vendor Name but shows the
number instead. I'm going nuts!

 

[Niniel]

You shouldn't have deleted the "0" value, that just hides the key column. The
value after the semicolon was your name column. So now instead of displaying
columns 1 and 2 [key and name, and since key was 0 wide you didn't see it],
it just shows column 1, which happens to be the ID field.

 

[Rich D]

If that's the case, why am I getting this dang message? What can I do to
make it work so I don't get the message?
--
Rich D
Armstrong Custom Homes
Redmond

You shouldn't have deleted the "0" value, that just hides the key column. The
value after the semicolon was your name column. So now instead of displaying
columns 1 and 2 [key and name, and since key was 0 wide you didn't see it],
it just shows column 1, which happens to be the ID field.

I have a Combo box which limits me to the names on the list. I want to be
able to put in my own name (not on the list). It says I can't. So I went to
properties and changed the "limit to list" to NO. Then it tells me to change
the "Column Widths" because the first visible column is not equal to the
bound column. I go to Column Widths property and it says: 0";1.698". I
delete the 0"; When I go back to Limit to List it says NO. Great! Then when
I open the Form, I get a parameter box that says "lookup_combo42,VendorName".
I click OK, it goes into the form but instead of displaying the Vendor Name,
it shows the ID # 10, whichcorresponds to the right Vendor Name but shows the
number instead. I'm going nuts!

 

[chriske911]

Rich D pretended :

If that's the case, why am I getting this dang message? What can I do to
make it work so I don't get the message?

You shouldn't have deleted the "0" value, that just hides the key column.
The value after the semicolon was your name column. So now instead of
displaying columns 1 and 2 [key and name, and since key was 0 wide you
didn't see it], it just shows column 1, which happens to be the ID field.

:

it is rather logical
the column you are hiding cannot be seen
therefore there is no way a user can put in a value in that 1st column

but why would you use a multi column combo box to add new values?
is it a lookup combo box?
then you can type in a value that is in the list
there would be no point of looking up something that is not there to
begin with

could be that I am missing something here but I have never considered
using a multi column combo box as an input field in a form so I
actually have no idea if this were possible

grtz