M
mcgj
I am using a Like Forms!myForm!cmbMyBox in query to get data based on what is
in cmbMyBox. If the user leaves it blank the cmbMyBox defaults to * which
returns all records. So it was working good until I found some records in
the table that have blanks in the column that cmbMyBox references. Those
records are not returned by my query in * mode.
I cannot modify the table to make the value required because it is not mine,
it is a linked table from another program. Does anyone have a slick way out
of this jam?
in cmbMyBox. If the user leaves it blank the cmbMyBox defaults to * which
returns all records. So it was working good until I found some records in
the table that have blanks in the column that cmbMyBox references. Those
records are not returned by my query in * mode.
I cannot modify the table to make the value required because it is not mine,
it is a linked table from another program. Does anyone have a slick way out
of this jam?