Query/Form Question

  • Thread starter Thread starter David
  • Start date Start date
D

David

I did something similar to a combobox, but this will be different.
I have got a form that is populated by a query,
-so far so good-
I am wanting to put a checkbox on the form to hide certain values in a
specific field containing a specific word at the begining of the data,
"OLD",
How do you get the query to look at the checkbox and change its criteria?
 
Put new checkbox on the form and leave it unbound
Create procedure for event: OnCurrent()
Sub Form_Current(
Me.CheckBox1 = Iif(Me.Fields("YourField") = "OLD", True, False
End Sub
 
Back
Top