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
 
You must log in or register to reply here.

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

Similar Threads

Need combo box to refresh when moving to new record 2017 1
How do I select multiple rows of data on a form 3
Creating Checkbox Fields For Every Record 0
Getting CmbBxColumn from within query 1
modifying Kallal's Multiselect database example 3
checkbox on form not working 2
Using QueryDefs to Build a Dynamic Query in Access 6
Access Form Update Query 3

Back
Top