Preventing Add/Delete on Subform (1 Viewer)

MBruns · Mar 22, 2004

I've got a subform that I want to keep people from editing while allowing them to view all the data that's on there. Based on who they are and whether they should be able to edit or not I lock them out of editing the main form and various controls on the subform. I have code that theoretically locks the subform, but as far as I can tell it doesn't do anything.

The controls on the subform get locked by code like:

Forms!frmInputMainByEntry.Form!FrmSubInputDetail!Hours.Locked = True

This works for keeping users from editing the individual fields, but not from adding or deleting records from the subform. The subform doesn't seem to have the same allowadditions property the main form does. I can set the enable property to no for the subform, but then people can't scroll to the bottom of the subform entries.

Any ideas?

Thanks,

Mike Bruns

jfgambit · Mar 22, 2004

In the Properties of the form set the Allow Additions and Allow Deletions to "NO"

HTH

MBruns · Mar 23, 2004

Is there a way to do this just for the subform

jfgambit said:
In the Properties of the form set the Allow Additions and Allow Deletions to "NO"

HTH

I know I can do it on the main form properties, but what about the subform....Thanks

a.sinatra · Mar 23, 2004

MBruns said:
I know I can do it on the main form properties, but what about the subform....Thanks

Ya.. ok? It works the same way for the subform.

________
oxygen vaporizer

Mile-O · Mar 23, 2004

MBruns said:
I know I can do it on the main form properties, but what about the subform

A subform is just the same as any form. In fact it is a form. It's just embedded within a form. They both have the same properties throughout.

MBruns · Mar 23, 2004

Am I missing something

Mile-O-Phile said:
A subform is just the same as any form. In fact it is a form. It's just embedded within a form. They both have the same properties throughout.

When I click on the subform I get two sets of things. Single click I get onEnter and OnExit events. Click again, I get a list like a regular form. However when I try to refer to the subforms' "AllowDeletions/Additions" properties I get an error message saying the object I'm referring to doesn't support those properties.

Does anyone have a basic syntax to refer to the subform Allow deletions properties from a main form event example?

It seems like this should be simple, but it's not. I have no problem referring to individual controls and locking them on the subform, but referencing the subforms allow additions and allow deletions has me baffled.

MBruns · Mar 25, 2004

Here's my answer

So here's the answer I found. Yes, it's true that subforms have the same properties, I just couldn't get the syntax to refer to them right. Here's an example:

Forms!frmInputMainbyEntry.Form!FrmSubInputDetail.Form.AllowDeletions = False

This does the trick.

kons21 · Dec 2, 2019

I have a similar issue, bit a bit more specific.

I have the "additions/deletions" set to "no." When the form loads initially the user cannot add or delete records.

However....

I also want the user to be able to sort/filter the subform. I am using "Browse to" function to do that. After I use the "browse to" function the "New Record" line shows up again, and the user is able to again try to add new records or delete records.

Does anyone know a workaround this?

theDBguy · Dec 2, 2019

kons21 said:
I have a similar issue, bit a bit more specific.

I have the "additions/deletions" set to "no." When the form loads initially the user cannot add or delete records.

However....

I also want the user to be able to sort/filter the subform. I am using "Browse to" function to do that. After I use the "browse to" function the "New Record" line shows up again, and the user is able to again try to add new records or delete records.

Does anyone know a workaround this?

Hi. Welcome to AWF! Recommend starting your own thread, since this is a 15-year old thread.

Preventing Add/Delete on Subform (1 Viewer)

MBruns

New member

jfgambit

Kinetic Card Dealer

MBruns

New member

a.sinatra

quik

Mile-O

Back once again...

MBruns

New member

MBruns

New member

kons21

New member

theDBguy

I’m here to help

Similar threads

Users who are viewing this thread