Access datasheet

C

CAM

Thanks to "bcap" for his help regarding form and attaching a datasheet. I
was able to create a form containing a sub-form containing a datasheet,
properly linking the require field. It works fine, but my problem is when I
want to change the data in the datasheet I am unable to do that. Can some
help out? I want to change the data only on the datasheet, which contains 4
columns - column 1 is call "Code", column 2 - Eff_Date", column 3 -
"Comments", column 4 - "Select Record" (a check box). What I really like
to do is change data only in two columns "Select Record" and "Comments" I
want to give this option to the user. I was able to lock the fields in the
form, which I want, but I can't change anything in the datasheet, again I
need to do that with only 2 columns to change only. How do I do that?

Any tips or website to visit is appreciated. Thank you in advance.

Cheers
 
L

Linq Adams via AccessMonster.com

Is the subform based on a table or a query? If it's based on a query, can you
edit these fields when you open the underlying query? Akk queries aren't
editable.

"I was able to lock the fields in the form"

Are you talking about the MAIN form or the entire form, which includes the
subform? And ***how*** did you lock these fields? When a form is displayed as
a subform, the AllowEdits, AllowAdditions, etc properties of this form ***are
ignored by Access*** and these properties are controlled by how the
properties are set in the MAIN form. So if the MAIN form AllowEdits is set to
No, and the SUBFORM AllowEdits is set to Yes, you still won't be able to edit
the subform.
 
Top