Combo Box question

G

gweasel

I need to set up a control on a form that is bound to an existing
table. I'm thinking a combo box makes the most sense, but here's what
I've got to do with the control.

The table has roughly 100 entries.
These will filter based on previous combo boxes - so hopefully it
won't be too overwhelming to select from.
It has to limit to list (because I only want one column to show in the
dropdown, but it sorts by another column)

Is there a way to set this up to where if the user enters something
that is NOT in the list it will accept it but not save it into the
list. I'd like it to save the value, but not make it a permanent
option on the form.

Thanks in advance.
RJB
 
G

gweasel

I have tried that, but since it is sorted by a column that is not
showing (and needs to remain that way), it won't allow me to set
"Limit to List" to No. Also, Limit to List will not allow records to
be entered in that aren't saved in the table...at least now any way
that I know of.
 
R

Ron2006

From your description, I am assuming that the combo is NOT bound to
Click to expand...
any field itself.
If that is so, then in the Data Row Source, make the sort field
included in the output of the query - make it/them the last field(s).
But then
go to the number of columns and add the number of added fields to that
number,
go to the field lengths and add ;0" for each field you added.
Make sure that the limit to list is set to NO

I just ran a test and that configuration allowed me to enter values
not in the table

My guess is that even if it were bound to a field this would work, but
you would be changing the data in the field also. But this may be what
you want.

Ron
 
Top