Combo and List box's

J

John Melbourne

I have been experamenting with combo and list box's in my forms but neither
seem to be able to do what I want them to do.

I want a text box (with a label - eg. Name) and a down arrow to one side
which pulls down a menu of names that can be selected(combo box), but the
user also has the option of typing a name that is not in the list.

How do I do that?
 
L

ldiaz

in Combobox properties, select DATA tab,in field "Limit to List" = YES.

I hope this help yoo..

ldiaz
 
A

Al Camp

That is what a combobox does...
You define which Names that will show in the combobox by using a table or
query in the RowSource property of the combobox.
The combobox ControlSource property should be set to the field from the
table behind your form that you want the selected Name "saved" (bound) to.
Don't name your combo "Name"... that's a reserved word... call it CustName,
or ClientName, etc...
Another property of the combobox is LimitToList... and if you set that
property to NO, then you could select a name from the drop down... or...
enter a new name at any time.

It's not within the scope of a newsgroup to give a complete tutorial on
comboboxes. I cited some basics that should get you going, but you'll have
to get in there and learn...

I would suggest using Help to get some rudimentary information about
creating, configuring, and using comboboxes, and if your learning Access...
you should have at least one reference book available as a back up the
resident Access Help.
Also, try searching the web for other resources...

hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
 
J

John Melbourne

Thanks You

Have a good day
--
enruoblem


ldiaz said:
in Combobox properties, select DATA tab,in field "Limit to List" = YES.

I hope this help yoo..

ldiaz
Click to expand...
 
A

Al Camp

John,
You wrote...That would require that NotInList = No (not Yes as ldiaz indicated)
 
Top