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.
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.