I was hoping someone would help me with VBA code that is way beyond my capabilities right now. I assume this is possible to do.
When the Toggle Button named ToggleBid is clicked and its value is = True then
have code that would run through each record in a table (tblNavigator) and check on a field named "Bid_Tracker" if that records value in the Bid_Tracker field = "True" then set the value in the Field named "Toggle_Condition" to "True".
Your help us very much appreciated, this would make things much easier for the users.
****Additional Information*********
Not sure an Update meets my needs, I am not changing the field Bid_Tracker that has the True in it and I don't want to change Every record in the table. I just want the Field "Toggle_Condition to equal True if the field Bid_Tracker = "True"
Like I said, I am new so maybe I don't understand all the capabilities of an Update query
I was also going to use the code for a second and third toggle based on fields in addition to the Bid_Tracker. I know enough VBA from Excel to be able to take what someone helped out with and modify it. Then I was going run a query on the table (after the requested code above) to show only records where the Toggle_Condition was true.