Criteria

B

Bruce Rodtnick

I have a form that is using a criteria field in its RecordSource. I
have a ComboBox that has a Value List of Active;Recorded;etc..., in its
row source.

This form pulls from a table that looks at the field "Status" and pulls
into that form those who have The RecordSource is supposed to pull in
anyone who has Active or or Recorded in the status field. The criteria
field reads "Active" OR "Recorded". When I run the query by itself it
pulls all the names of both Active and Recorded, but when I run the form
only Active is brought in. What am I missing?

Bruce Rodtnick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top