Subform lock selected columns only

[reez88]

Hi,

Is there anyway to lock some columns in a subform and leave others editable?

I have attached a database below. In the form 'frmAttendances' I like to keep the 'present' column editable and lock the rest out.

I know if I use a continuous form and have separate controls this is possible. But I like the look of a datasheet.

 

[jdraw]

accdb can not be opened by Users with Access < 2007

You may get more responders if you attach a copy in mdb format.

 

[reez88]

thanks for the information.

I have attached a file in mdb format here..

 

[missinglinq]

Your Subform is based directly on your Query, qryAttendanceSubform, which doesn't give you the ability to lock Controls. You need to

1. Create a Form based on this Query
2. In Design View of this Form, lock the desired Controls
3. Go into Design View for your Main Form, frmAttendances and change the SourceObject for the Subform from the Query to your newly created Form.

Linq ;0)>

 

[reez88]

Thanks a lot Linq,

I have followed your instructions and the form behaves exactly the way I wanted it to.

Many Thanks.

 

[missinglinq]

Glad we could help!

Linq ;0)>