By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,165 Members | 850 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,165 IT Pros & Developers. It's quick & easy.

Change Selected Record on Continuous subForm

P: 9
I have a subform which is bound to the contents of the Asset table. at the end of each row i have also added an 'edit' button and a 'Delete' button.

All textbox controls have been locked by default to ensure that the user dosent acidently change the data in the table.

What i would like to do is when the user clicks on the 'edit' button for that record it unlocks all the controls (and perhaps changes the background colour)

I have got the records to delete with the del button using Me!Recordset.Delete however not sure of the best way to change the control boxes Locked setting.
Any Ideas?
Many Thanks
Mar 5 '07 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 10K+
P: 12,366
You can set each control to unlock or lock using the code:
[Control Name].Locked = True/False
Mar 5 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.