Making record not show on form, based on True/False value

[Jarad]

I have a form that displays records, But I want it to only pull records that are in the table as of now, any new records will be flagged by default as "false". So basically, I just want the fields marked as "True" on the RECEIVED field to be pulled in to the form. Have everything lined out, but cant get the form to pull in only those fields marked as "TRUE" Any Ideas?

 

[RuralGuy]

Use a query as the RecordSource for the form. Put True in the Criteria row of the RECEIVED field. Keep experimenting in the query builder until you get the results you are looking for.

 

[missinglinq]

RuralGuy's idea is a hack I've used for years! It allows you to retain a record, rather than actually "deleting" it, and "reinstating" it by simply changing the value of a Yes/No field! All you have to do, in your query, is set the Criteria to Yes or No, depending on how you have it set up!