Solved Empty Combo Box (1 Viewer)

Tieval

Still Clueless
Local time
Today, 22:21
Joined
Jun 26, 2015
Messages
475
I have a query that has values for different fields such as:
1 Type A
2 Type B
3 Type C
(and many more)

This query is used to generate a continuous sub-form from data such as:
Record Description Value
008 An Item Type A
009 Another Item Type B

A combo box on the main form allows you to sort the values so selecting Type A would only show these.

My question is how to show all values when the form first loads as there is no selection in the combo box, I can obviously set a default value as 1, 2 or 3 to default to that dataset but can really see a use for showing everything.

Using LIKE doesn't help as when you select 1 you would also get 10, 11 etc..

Any help would be greatly appreciated.
 

Minty

AWF VIP
Local time
Today, 22:21
Joined
Jul 26, 2013
Messages
9,238
Is your combo referred to in the forms underlying query? If it is you can add the following to the criteria

=[forms]![YourForm]![cboYourCombo] or [forms]![YourForm]![cboYourCombo] Is Null

A null combo value will now return all values.
 

Tieval

Still Clueless
Local time
Today, 22:21
Joined
Jun 26, 2015
Messages
475
As simple as that :sneaky:

Many thanks for your help Minty.
 

Users who are viewing this thread

Top Bottom