hey there
i have a form with textbox "txt_Region" and the value is used as a parameter in a crosstab qry.
the values that i type in the text box are Numbers (1,2,3.....9) though. the issue is that in the qry that is parameterized it pulls from a table where the Region field is a text...it was build prior to me taking it over.
therefore, i declared the parameter Forms!FormName!txt_Region as Text.
if i go to the form and type in 2....then attempt to run the qry....i get no records.
if i remove the qry criteria ([Forms]![FormName]![txt_Region] and replace it with a 2, access auto quotes on the crieteria as "2" and then the qry returns records.
tis kind of goofy but might there be a work around? do i need to set the props of the txt box?
T
i have a form with textbox "txt_Region" and the value is used as a parameter in a crosstab qry.
the values that i type in the text box are Numbers (1,2,3.....9) though. the issue is that in the qry that is parameterized it pulls from a table where the Region field is a text...it was build prior to me taking it over.
therefore, i declared the parameter Forms!FormName!txt_Region as Text.
if i go to the form and type in 2....then attempt to run the qry....i get no records.
if i remove the qry criteria ([Forms]![FormName]![txt_Region] and replace it with a 2, access auto quotes on the crieteria as "2" and then the qry returns records.
tis kind of goofy but might there be a work around? do i need to set the props of the txt box?
T
Last edited: