Coloms filling

[michelle]

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]

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]

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.