How do I crete read only fields in a query?

[chris01252]

My problem is as follows:

User group 1 enters information into a table via a form.

This information then needs to be signed off by user group 2. I have created a query which shows the information in fields 1 to 10 which I want to be protected so they can only view this and not edit it and then have a couple of fields at the end where they can enter their name and any comments.

Simply my question is can I have a query with some protected fields and some un protected or is it one or the other? If this is not possible please suggest an alternative.

 

[Brian1960]

Form Security

Whe you display the data in the form make sure that the fields are all locked apart from the 2 you need to have the users edit.

 

[chris01252]

cheers mate I knew it would be a stupidly simple solution, think I have a knack for over complicating things, lol.