Selective Edit Capability in a Subform?

[JamesDC]

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

[Rabbit]

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.

[JamesDC]

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

[Rabbit]

It should work. Open up the subform in design view and make the changes to the controls there.

[JamesDC]

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

[Rabbit]

Glad you got it working.