Save Form design using VBA after changing it with VBA

markzaal

Registered User.
Local time
Today, 22:36
Joined
Jan 15, 2013
Messages
50
Access 2010

Hi all,

I have a form with many buttons on it. Each button opens a different form. If the user finishes this From he/she can click the "Finished" button. This closes the form, goes back to the original form with all the buttons and turns the first button green (Forms!NewForms!Distribution.BackColor = vbGreen), indicating that that form is finished. This way the user can go through all buttons, filling in all forms, until all buttons are green.
If the user however wants to stop half way he/she can close the main form and exit.
But when I now open the main form, none of the buttons is green anymore!
Any ideas on how I can save this design change?

Many thanks!

Mark
 
This is not and should not be a design change. You use button colours as markers for some information. Then you should store that information permanently as any other db information: in a table. USe that info to give the buttons appropriate colours On Load, and whenever user clicks a button update the table, as well as the colour. Oh yeah - and for multiusers - take care to discern between the users' button data.
 
There will actually be only one user who fills in the forms (1 per day) per project of 6 weeks. Each day this user will go through all the forms (buttons) and start over the next day. I see your solution and agree that it would have been better that way. If however I could only just save the changes in button colour, my problem would be solved (agreed, not in the most elegant way, but it works...)
 

Users who are viewing this thread

Back
Top Bottom