L
Ladybird
Combobox on a form is the record source for the criteria in an update Query
which holds the "Between xxx And xxx" values I wish to apply.
The rows are literally "Between" "And" in text format held in a table, for
eg: table rows 1 to 5 look like this:
1;Between 0.55 And 1.49;
2;Between 1.50 And 1.59;
3;Between 0.60 And 1.69;
4;Between 0.70 And 1.79;
5;Between 0.80 And 1.89;
At the moment update query is not finding the combobox row selected.
Current Criteria code is:
[Forms]![Frm_NEW_PRICE_RANGE]![Combo5]
which holds the "Between xxx And xxx" values I wish to apply.
The rows are literally "Between" "And" in text format held in a table, for
eg: table rows 1 to 5 look like this:
1;Between 0.55 And 1.49;
2;Between 1.50 And 1.59;
3;Between 0.60 And 1.69;
4;Between 0.70 And 1.79;
5;Between 0.80 And 1.89;
At the moment update query is not finding the combobox row selected.
Current Criteria code is:
[Forms]![Frm_NEW_PRICE_RANGE]![Combo5]