Solved Empty Combo Box

Tieval

Still Clueless
Local time
Today, 11:28
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.
 
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.
 
As simple as that :sneaky:

Many thanks for your help Minty.
 

Users who are viewing this thread

Back
Top Bottom