Combo and List box's

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

Guest

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?
 
in Combobox properties, select DATA tab,in field "Limit to List" = YES.

I hope this help yoo..

ldiaz
 
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
 
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
 
John,
You wrote...That would require that NotInList = No (not Yes as ldiaz indicated)
 

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

Back
Top