Recent content by Loup

Ok so on Form 1 of the attached db, I would like it so the user can edit all the fields but "number"

Thanks everyone and apologies I haven't been at my desk today so I haven't been able to post my db.

I only want to lock some of the fields because there is information I do not want to be altered inadvertently. After the table on the form is set up correctly I will then set it to open in form view and not in design mode.

Thanks, Bob I only cross posted because on the other forum no one could understand what I was trying to do. Fresh eyes often have a fresh perspective so I will continue to do this in the future if required. That Micron individual seemed to want to split hairs and blame me for him not knowing how...

Thanks for the reply Ok say you have 10 fields in a table, you want to display this table on a form so that when the user opens it, that's all they see, then also suppose you want them to be able to update 5 of those 10 fields but not the other ones. That is what I am trying to do. I already...

Hi All What I am trying to do, is use a form to display a table and then using that form only allow certain fields to be edited; this would apply to all records. I would really appreciate some help