Multiple Default Values in ComboBox

[Access1981]

Hi,

could somebody please explain how I can set multiple default values in a ComboBox in a form. The ComboBox is based on a table and my main table also uses the ComboBox.

Example:

Main table has a column "Brands". The ComboBox is based on another table which includes the following items (and thus the ComboBox also shows them):

- CocaCola
- Fanta
- Sprite

The form has the same ComboBox which is linked to the main table.

Now, if a user creates a new form entry, all ComboBox items should be preselected (checked). It does work with one item over the standard "Default" property.

Have been trying this for hours, help is much appreciated.

Cheers,

Al

 

[vbaInet]

The ComboBox is based on a table and my main table also uses the ComboBox.

Table lookups aren't good practice and her'es why:
http://access.mvps.org/access/lookupfields.htm

The ComboBox is based on a table and my main table also uses the ComboBox.

Example:

Main table has a column "Brands". The ComboBox is based on another table which includes the following items (and thus the ComboBox also shows them):

- CocaCola
- Fanta
- Sprite

The form has the same ComboBox which is linked to the main table.

Now, if a user creates a new form entry, all ComboBox items should be preselected (checked). It does work with one item over the standard "Default" property.

All of this didn't make sense to me. Can you elaborate?

 

[Access1981]

Thank you for the reply.

Could you maybe provide a link that explains the "best practice" alternative to the lookup?

Regarding the second part, I wanted to give additional detail but may have complicated things.

Basically what I want is that if a new entry is created via the form, the lookup values are all checked by default, so the user has to deselect instead of select them. So in a new form entry, the lookup box should be:

[v] CocaCola
[v] Fanta
[v] Sprite

by default instead of

[ ] CocaCola
[ ] Fanta
[ ] Sprite


Thanks again and have a nice day!

Cheers,

Al

 

[Mile-O]

Just to verify one thing...when you say combobox you actually mean a listbox, right? The reason I ask is because a combo can only have one value, so when you talk about multiple values...well, you know.

 

[Access1981]

Very new to Access, so I am not sure about what it is. I think ComboBox with multiple values. By clicking the field you get a list with tickboxes. Multiple boxes can be ticked. The ComboBox value options are based on another table.

Property sheet reads:

Selection type: Combo Box
Row Source: SELECT [TableBrands].[Brands] FROM [TableBrands];
Row Source Type: Table/Query