check box malfunction

[angie]

i have created a a check box in my form in order to filter records based on a
field. Specifically when the check box is selected i want to filter records
in stock in the warehouse (i.e. fieldname=inventory >0 ). i have create a
macro with ApplyFilter Action and is working. i select the check box and the
records are filtered. the problem is that when i deselect the checkbox the
filter is not removed.

how can i make the checkbox to work properly?

 

[Jeff Boyce]

Angie

How does your checkbox "know" to run the macro?

Does either your checkbox or your macro "know" when the checkbox is
un-checked?

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[angie]

i have assigned the macro on th OnClick event of the checkbox. i think that
neither the checkbox nor the macro knows when it is unchecked.

how could i fix this?

Ο χÏήστης "Jeff Boyce" έγγÏαψε:

 

[Jeff Boyce]

Modify the macro to handle conditions?

If you can't do this in the macro, it would be a small, simple bit of code
in an event procedure connected to the 'click' event.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/