Ok, I'm stuck on how I should do this. Here's what I'm doing.
Button on my form called button1. When I clicke on button1 an audit table inserts a record with "Button1" and my label called lblButton1 is set to visable. (check box, showing me the button has been launched)
When I close the DB, but Button1 label goes back to hidden. I'm trying to use the OnLoad event to code and check my audit table to see if "Button1" exists in the audit table. If so, make my lblButton1 visable.
I know I can use a record set and go look for the word "button1" but I have more than just this 1 button on the form and will need to do this on every button. Is there a better way then build a a recordset for each button? So I'm not going to the DB for each button?
Button on my form called button1. When I clicke on button1 an audit table inserts a record with "Button1" and my label called lblButton1 is set to visable. (check box, showing me the button has been launched)
When I close the DB, but Button1 label goes back to hidden. I'm trying to use the OnLoad event to code and check my audit table to see if "Button1" exists in the audit table. If so, make my lblButton1 visable.
I know I can use a record set and go look for the word "button1" but I have more than just this 1 button on the form and will need to do this on every button. Is there a better way then build a a recordset for each button? So I'm not going to the DB for each button?
Comment