Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!news.albasani.net!feeder.news-service.com!news2.euro.net!multikabel.net!newsfeed20.multikabel.net!post30.multikabel.net!cache110.multikabel.net!not-for-mail From: Newsgroups: comp.databases.ms-access Subject: Determine what the main form Date: Sat, 2 Apr 2011 22:03:20 +0200 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal Importance: Normal X-Newsreader: Microsoft Windows Live Mail 15.4.3508.1109 X-MimeOLE: Produced By Microsoft MimeOLE V15.4.3508.1109 Message-ID: <2ae24$4d97810e$5356be6c$15797@cache110.multikabel.net> X-Complaints-To: abuse.cas.news@prolocation.net Organization: Multikabel Lines: 12 NNTP-Posting-Host: 83.86.190.108 (83.86.190.108) NNTP-Posting-Date: Sat, 02 Apr 2011 22:03:26 +0200 X-Trace: 2ae244d97810ef6f31bc915797 Xref: x330-a1.tempe.blueboxinc.net comp.databases.ms-access:771 I have a subform which I've always used in one main form. Now I would like to use the same subform in another main form, only the subform then needs a different record source and the behavior of the subform should at some points be slightly different which I'm planning to do in VBA. My questions are: how can I check in my subform by which mainform it is opened? And secondly: can I safely use the subform in 2 mainforms at the same time? Thank you, Martin