Pulling criteria froma form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have form based on a query. I have two unbound check boxes on the form.

I am trying to pull the value in these check boxes into the criteria of two
of the fields in the underlying query. This should have the effect of
limiting the records in the form.

I have entered [Forms]![frm_DealMaster]![test] which is the name of one of
the unbound criteria fields in the form but, when I try to run the query, I
get the "Enter Parameter value" error.

What am I doing wrong?
 
I tried duplicating your situation, but Access 2002 let me filter based on an
unbound check box on the form. Check:

- Your spelling of the form name and *control* name on the form
- That the field you are filtering is a Yes/No field

Hope that helps.
Sprinks
 
I checked both itesm. I'm using the builder to grab the form field so
spelling isn'r the issue. The query field is an expressing but I changes to
format to yes/no. I don't think that's issue though becasue it can't locate
the form field at all for some reason.

Sprinks said:
I tried duplicating your situation, but Access 2002 let me filter based on an
unbound check box on the form. Check:

- Your spelling of the form name and *control* name on the form
- That the field you are filtering is a Yes/No field

Hope that helps.
Sprinks

Bdavis said:
I have form based on a query. I have two unbound check boxes on the form.

I am trying to pull the value in these check boxes into the criteria of two
of the fields in the underlying query. This should have the effect of
limiting the records in the form.

I have entered [Forms]![frm_DealMaster]![test] which is the name of one of
the unbound criteria fields in the form but, when I try to run the query, I
get the "Enter Parameter value" error.

What am I doing wrong?
Click to expand...
Click to expand...
 
Back
Top