Parent form subform challenge - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Parent form subform challenge

David Cummins

2 years ago

I have a parent form called Clients and a sub form with items related to the parent client form.

I want users to edit related items in a sub form without editing & deleting the names of the clients in the client parent form. In other words, I just want to only display the client names but lock out the name fields. I tried several methods to do this but with no effect. Is this possible to do in Access parent/sub form configurations?

	John Davy @Reply 2 years ago
Hi David You could simply lock the fields in the parent form (under data tab) John

David Cummins OP @Reply

2 years ago

Hi John,

I actually want to edit a sub form embedded in a locked parent form but, apparently, locking fields in the parent form applies globally to the sub form. I will apply VBA to allow users to edit but it would be nice of Microsoft updated Access to allow sub form editing on a locked parent form. Power Apps can lock out fields that Access cannot do, so I may develop in that environment down the road.

Thanks.

	John Davy @Reply 2 years ago
Hi David I said lock the fields on the parent form NOT the form itself John

	John Davy @Reply 2 years ago
Hi David Select the fields on the parent form while in design mode. go to Data, the select lock. This will lock only those fields. Try it. John

	David Cummins OP @Reply 2 years ago
Hi John, I tried that too. I'm using Dataverse which is the problem. Thanks

	Richard Rost @Reply 2 years ago
Your data source shouldn't matter. If you set the FIELD properties to LOCKED for whatever fields you don't want them editing, that should work for what you want.

	David Cummins OP @Reply 2 years ago
Thanks Richard but I cannot get this to work. Should I move my tables to SharePoint? I don't think Dataverse is designed to support Access.

	David Cummins OP @Reply 2 years ago
Richard, Dataverse also does not support extended tables. I am not sure if DV is designed for to support pro database applications.

	Richard Rost @Reply 2 years ago
Sharepoint is an option, but I strongly recommend SQL Server. You can get web-hosting and SQL server for less than $10 a month with Winhost, which is what I use.

	David Cummins OP @Reply 2 years ago
Thanks, Richard. I think I can get the budget for that. The challenge is trying to get my organization to scale down their MS 365-platform license. The platform, including SharePoint, is built on old legacy tech that is poorly designed with virtually no consideration for UX and UI. Aside from Access, not a big Microsoft fan.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View