Getting the name of the main form

M

Manfred 1st

It is rather easy to get the name of the subform from the main form since it is recorded in "SourceObject". But what is the correct way of determining the name of the main form from the subform (with other words: To write data back from subform to main form on events in subform). This is important since my subform can be used by more than just one main form and I must be able to write values back to the current main form. But which form...??

Thank you for your hel

Manfred 1st
 
S

Steve Schapel

Manfred,

Me.Parent.Name will give you the name of the main form. You can refer
to controls on the main form by Me.Parent!ControlName
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate main form from subform record 0
VBA code returns no records hwenKey ID is added 14
Requery main form after subform update and not lose place in main form. 3
showing a subform based on the main form 5
Passing a value from subform or main form to subform query 4
Refresh data in sub forms when one sub form is edited 8
referring to Subform Total in main form 1
Requery subform control from Main form 0

Top