View Full Version : Coloms filling


michelle
03-13-2000, 05:45 AM
Hello Form users,

I am a VB user and I do have to make a form in ACCESS.
In VB you can fill a combo box with:

Combo.Additem "test"

The additem property is not find in the form for the combo box.

Can someone tell me how to fill a combo box?

Nice greetings,

Michelle.

Danny Clarke
03-13-2000, 06:55 AM
Hi Michelle!
I think I can help you out while all the Americans are still in bed...

You need to use something like:

Forms![Your Form]![Combo Box].Caption="test"

I hope that works for you!

wilycat
03-13-2000, 03:26 PM
There are actually several ways to fill a combo box (its different in Access than in VB, no AddItem).

You can fill it from a list, from a table or query, or via code. In fact, if you have the wizards turned on, when you draw the combo box a dialog will ask you for your preferences. Typically, a small static list will be filled by a 'list'. Dynamic data will require a table or query.

You can also use code, but be aware: This is not a trivial task in Access!

Help for these tasks can be found by searching the Access help for RowSource Property and related items.