Finding the Parent form for a subform Access97

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Sorry for the cross post but since there are two forms coding groups I did
not know which one to post to, it looks like this group gets more traffic so
I thought I would post here as well. If cross posting between the two groups
is a no-no please let me know which is the correct group to use.

Now for the question.

I have a set of three subforms which are used in two different forms. One of
the forms is a search form where I allow the used of 'filter by form'. When
this is used the AllowEdits, AllowDeletions, and AllowAdditions property of
the subform are set to 'No'. I do not want this to be the property setting
in the other form but the properties do not change value back to 'Yes' when
the search form is closed.

So I thought I would capture which form opened the subform and set the
values for the AllowXX properties based on the opening form.

I read through the help for the Parent property and it indicates you can use
the property to do exactly what I am wanting to do but there is no example of
the proper syntax to uses as well as which event to use in the subform to
capture this information and make the propery changes to the AllowXX
properties.

Any detailed assistance would be greatly appreciated.

Regards,
Tony
 
Tony Nichols said:
Sorry for the cross post but since there are two forms coding groups I did
not know which one to post to, it looks like this group gets more traffic so
I thought I would post here as well. If cross posting between the two groups
is a no-no please let me know which is the correct group to use.

Now for the question.

I have a set of three subforms which are used in two different forms. One of
the forms is a search form where I allow the used of 'filter by form'. When
this is used the AllowEdits, AllowDeletions, and AllowAdditions property of
the subform are set to 'No'. I do not want this to be the property setting
in the other form but the properties do not change value back to 'Yes' when
the search form is closed.

So I thought I would capture which form opened the subform and set the
values for the AllowXX properties based on the opening form.

I read through the help for the Parent property and it indicates you can use
the property to do exactly what I am wanting to do but there is no example of
the proper syntax to uses as well as which event to use in the subform to
capture this information and make the propery changes to the AllowXX
properties.

Any detailed assistance would be greatly appreciated.

Regards,
Tony
Click to expand...

If Me.Parent.Name = "frmSomething" Then...

Try putting your code in the subform's Open event.
 
Back
Top