Front-back end : form with write and read only fields

[DajTwo]

I am inquiring as to the best way to setup a form to have a user 'read only' the fields that are in the [readonly] table and 'read/write' in fields that are in the [write] table. Both tables have a Unique ID to link the records. The result should be on the same form. (Access 2003)


Understanding that the database will be separated in a front and back end when completed, can I link the form fields directly to the tables in question, have a drop down to select the record, identify the fields required as read only in properties.?

Would it be preferable to setup a query for the read only and a update query for the read/write?

Any advice would help

Thanks

 

[randy700]

Take a look at the Locked and Enabled properties of the controls on your form.


Randy

 

[DajTwo]

That was one of the possibilities i was looking into.

Would you suggest that I link the tables directly or proceed with queries to update the form?

(understanding that this is a front/back end database0

thanks

 

[randy700]

Whenever possible, I create my forms based on queries, not tables.


Randy

 

[DajTwo]

Thanks Randy.