Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

? re: creating combo/list boxes

Status
Not open for further replies.

gwendolyn8

IS-IT--Management
Feb 7, 2005
9
US
I'm going in circles with this Access book I'm reading. Basically, I'm designing a form to enter data, and I want most of the entries to have list boxes or combo boxes that give them very specific choices for what users can enter to keep the entries uniform and useful.

The only info I can find for either list or combo box only lets me choose the data entry options for the list/combo box from another table. There has to be a way that I can just type in options like "yes/no" or "laptop/desktop" without having to create a separate table for the box to access each set of entry options.

So, the million dollar question is does anyone know how to do what I'm trying to do? And then the thousand dollar question is does anyone know if I'm using the wrong vocabularly words here (combo and list boxes) and that the real thing I need to look up is called something else?

Thanks.
 
Hi gwendolyn8,

The wizard for a combobox will give you an option of if you want info from a table or second option create your own, so you select that option and enter your selection critera, Hope that helps,

M-.
 
With a combo box change the row source type to value list, in the row source type in your values seperated by semi colons

Yes;No;Maybe etc etc
 
Not sure what you meant by that, but in the row source of your combobox enter "Yes";"No";"Maybe" which will give user an option to choose either,
HTH,

M-.
 
How are ya gwendolyn8 . . . . .

When you start the [blue]combobox/listbox wizard[/blue], select the option that saids:
[blue]I will type in the values that I want[/blue]

Be aware: This is a [purple]Row Type[/purple] of [purple]Value List[/purple] and is [purple]limited to 2048 characters, including semicolons and spaces.[/purple]

Calvin.gif
See Ya! . . . . . .
 
You guys saved me! Thanks. I knew it was obvious, I just couldn't find anything in my book that covered it.

XOXO!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top