Show only data with checkbox TRUE

  • Thread starter Thread starter Malcolm
  • Start date Start date
M

Malcolm

Hi

I have a table with one of the fields being a checkbox. I
have a form that shows the info from this table. However,
I would like the form to only show the data if the
checkbox in the table is unchecked.

The Primary Key is "Security_ID" and the table is
called "Sedol Codes". The check box is called "Valid"

I am sure I need to write an SQL statement but I don't
know where and I don't know how. Is it in the expression
builder and what field do I click on??????

Many thanks

Malcolm
 
Create a query and set the criteria on the checkfield to true and use the
query as the data source of the form.
 
Back
Top