Hello.
I have a question concerning variable criteria for queries and reading
forms.
Let's say that I have a table with 2 fields and 10 records. One of the
fields can have two different values: A or B. Then let's say that I've
designed a slpit form. The right side of the form allows for data entry
while the left side allows for record filtering.
On the left side, the user can activate a control box or radio box to choose
between A and B records. As soon as he does that, the records are
automatically filtered.
I only know how to create critera with constants (criteria = "A")
QUESTION
-------------
The problems is this: How can I edit my query for it to look something like
this:
For field CHOICE, critera = comboChoice.Value from frmLeft
I tried entereing this, and it gave me "=[frmLeft].[comboChoice].value" or
something very close to this.
Thanks for your help!