Using IsLoaded with a subform

[SharynInCambodia]

I have been using IsLoaded for detecting if a form is open and linking a
second form to the open main form (it sets the foreign key in the second form
using the primary key from the main form).

This works fine, but now i want to use it from a subform to another form and
the IsLoaded code is not working. if i open up the subform separately as a
plain form, the code works and does what i want, but as a subform it does
not.
Any ideas on how to get it working.

 

[Allen Browne]

As you found, subforms are not open in their own right, so they are not part
of the Forms collection, and their IsLoaded property will not return True in
the AllForms collection.

If you really need to know this, you would need to:
a) Loop through the Forms collection, examining each in turn.
b) For each form, loop through its Controls collection.
c) For each control, if it is a subform control, examine its SourceObject to
see if it's the one you need.
d) Repeat steps (b) and (c) recursively (for the Form in the subform
control), so you handle nested subforms too.

That's not trivial to write. If the recursive part is new, here's an example
of a function that searches a form for subforms and calls itself
recursively:
http://allenbrowne.com/ser-56.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...

 

[msnews.microsoft.com]

find solutions of problems and solution regarding CISCO, CCNA, CCNP, MCSE,
LINUX, WIRELESS, SECURITY, NETWORK, IT NEWS

http://www.theitstuff.co.cc/

http://www.theitstuff.co.cc/understand-ospf-lsalink-state-advertisement-types/

http://www.theitstuff.co.cc/explore-different-types-of-ethical-hacking/

http://www.theitstuff.co.cc/what-network-management-covers/

http://www.theitstuff.co.cc/simple-network-management-protocol/

http://www.theitstuff.co.cc/important-consideration-in-designing-of-the-server-room/

http://www.theitstuff.co.cc/router-as-a-dhcp-server/

http://www.theitstuff.co.cc/assembling-a-motherboard-help-with-video-tutorial/

http://www.theitstuff.co.cc/ccna-and-ccnp-tutorial-vlan-trunking-protocol-vtp/

http://www.theitstuff.co.cc/nat-configuration-on-a-cisco-router/

http://www.theitstuff.co.cc/how-to-make-a-cat-6-network-cable-video-tutorials/

http://www.theitstuff.co.cc/types-of-network-attacks/

http://www.theitstuff.co.cc/advantages-of-optical-fiber-over-other-media/

http://www.theitstuff.co.cc/learn-tcp-ip-with-beautiful-animation-video/

http://www.theitstuff.co.cc/firewall-techniques/

 

[msnews.microsoft.com]

find solutions of problems and solution regarding CISCO, CCNA, CCNP, MCSE,
LINUX, WIRELESS, SECURITY, NETWORK, IT NEWS

http://www.theitstuff.co.cc/

http://www.theitstuff.co.cc/understand-ospf-lsalink-state-advertisement-types/

http://www.theitstuff.co.cc/explore-different-types-of-ethical-hacking/

http://www.theitstuff.co.cc/what-network-management-covers/

http://www.theitstuff.co.cc/simple-network-management-protocol/

http://www.theitstuff.co.cc/important-consideration-in-designing-of-the-server-room/

http://www.theitstuff.co.cc/router-as-a-dhcp-server/

http://www.theitstuff.co.cc/assembling-a-motherboard-help-with-video-tutorial/

http://www.theitstuff.co.cc/ccna-and-ccnp-tutorial-vlan-trunking-protocol-vtp/

http://www.theitstuff.co.cc/nat-configuration-on-a-cisco-router/

http://www.theitstuff.co.cc/how-to-make-a-cat-6-network-cable-video-tutorials/

http://www.theitstuff.co.cc/types-of-network-attacks/

http://www.theitstuff.co.cc/advantages-of-optical-fiber-over-other-media/

http://www.theitstuff.co.cc/learn-tcp-ip-with-beautiful-animation-video/

http://www.theitstuff.co.cc/firewall-techniques/

 

[SharynInCambodia]

thanks allen for replying
maybe i'll just re-write and have it open as a linked form - looks complex