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

Selective Edit Capability in a Subform?

JamesDC
P: 66
Hey all,

I'm working with Access 2002, and I have a subform which gives access to a Table called Product_Values. This subform's purpose is to allow the user to edit the $ values of the products without having to open the background information of the database.

This table has Product ID, Product Name, and Value headings, and I want the user to only be able to edit the Value area. If a Product name is changed there could be serious side effects on the rest of the database, so getting the other fields locked is a top priority. Is there a way to lock these areas while still allowing the user the ability to edit the Value area?

Thanks,

James
Mar 5 '07 #1
Share this Question
Share on Google+
5 Replies


Rabbit
Expert Mod 10K+
P: 12,366
You can do one of two things. Either turn off the visibility of the control that is bound to the field or you can set the locked property to yes.
Mar 5 '07 #2

JamesDC
P: 66
I tried turning off the Visible option and it did nothing :(

Also, there does not appear to be a Lock option for these areas on the subform.

Thanks for the suggestions but they don't seem to work, or I'm just missing something :S
Mar 5 '07 #3

Rabbit
Expert Mod 10K+
P: 12,366
It should work. Open up the subform in design view and make the changes to the controls there.
Mar 5 '07 #4

JamesDC
P: 66
Hey Rabbit,

I was looking at the subform I had on a form, not the actual subform. Thus I couldnt find the options. They're set to locked now and it's working well :)

Thanks,

James
Mar 6 '07 #5

Rabbit
Expert Mod 10K+
P: 12,366
Glad you got it working.
Mar 6 '07 #6

Post your reply

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