Solved Empty Combo Box (1 Viewer)

[Tieval]

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]

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]

As simple as that

Many thanks for your help Minty.