View Full Version : Forms - Auto populate Vs. Type in text


thesilverwolfie
10-09-2001, 06:13 AM
I have a combo box that I have made to where it will auto populate two lists boxs with information from queries and tables. The question I have is can you set it up so that if the information isnt' in the combo box then you type in what you need and be able to type in the two fields that are normally autopopulated?

To clarify. When my combo box is certain things it will auto populate the two lists boxs...I want to also be able if the item isn't on the list in the combo box to be able to type it all in instead of auto populating. Is that possible can you do both in the same box? If so how.

Thanks

LQ
10-09-2001, 06:28 AM
Under the combobox properties, if you want users to be able to add choices, then you can say "No" to Limit to List. But I would caution you that when users are allowed to add to lists, lots of mistakes can get made.

HTH

thesilverwolfie
10-09-2001, 07:34 AM
I do not want them to be able to add to the list just be able to type into the boxes. They can already type into the combo box if they don't want the ones on the list. I just want them to be able to type into the List box as well if they don't choose from what's on the list because then it won't auto populate. Or is that even possible with a list box?

LQ
10-09-2001, 10:05 AM
I may not be understanding your question completely, but if you are asking whether or not you can add to a list box....No, as far as I know, a user cannot add new values to a list box. If you want them to be able to do that, then you should use a combobox instead.