Combobox row for Criteria

  • Thread starter Thread starter Ladybird
  • Start date Start date
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]
 
That will compare the value held in the field in the query with the text
string "Between 0.55 And 1.49", and hence you et no values

What you need to do is enter the following as a new field

Eval([FieldInQueryToCompare] & " " &
[Forms]![Frm_NEW_PRICE_RANGE]![Combo5])


and the following as the criteria

=True
 
Thank You
That did the trick...


JohnFol said:
That will compare the value held in the field in the query with the text
string "Between 0.55 And 1.49", and hence you et no values

What you need to do is enter the following as a new field

Eval([FieldInQueryToCompare] & " " &
[Forms]![Frm_NEW_PRICE_RANGE]![Combo5])


and the following as the criteria

=True

Ladybird said:
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]
 
Back
Top