Search results

Adendum: When I had the original code searching for f4567 all it would do is make the button red. It never would go blue.

I think a little of both. The table is setup as such: Vehicle Number : Vehicle Info : In service text text yes/no checkbox My query returns all three. I thought that I would have to check in service against vehicle number to get the right one, because here...

another way I also do this and use this format. In the actual code for check box on click: docmd.applyfilter , ,"field=whatever" if you have multiple checkboxes then have it set the other checkboxes to false.

All, I am having extreme trouble. I have to build a graphical system to quickly determine the status of a vehicle fleet. I have a table with the Vehicle Id and a yes no for status. I am querying the table and returning these two items. My problem is the code only works for the first record and...