Groups | Search | Server Info | Login | Register

Groups > comp.databases.ms-access > #790

Re: Determine what the main form

Show all headers | View raw

Arsene@selenium.net wrote:

>On Sat, 02 Apr 2011 15:38:24 -0500, Marshall Barton wrote:
>
>><martin@hotmail.com> wrote:
>>
>>>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?
>>
>>
>>Sure you can do that.  You can check the name of the main
>>form:
>>
>>Select Case Parent.Name
>>Case "main form 1"
>>   ...
>>Case "main form 2"
>>   ...
>>Case Else
>>   MsgBox "wrong main form or not a subform"
>>End Select
>
>
>So, in order to share one subform among multiple mainforms, should the
>above code (Select Case Parent.Name, etc.) be inserted in the
>subform's "On Load" event?


If you really need the subform to act differently in
different main forms, then you can put that kind of code
anywhere you need to figure out which main form it's in.

Don't forget that subforms are opened before the main form
so don't try to do it too early in the subform.  I think the
Load even should be OK but double check it.

I would try to avoid this kind of thing and serioously
consider the tradeoffs of doing this vs creating separate
subforms.

--
Marsh

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Determine what the main form <martin@hotmail.com> - 2011-04-02 22:03 +0200
  Re: Determine what the main form Marshall Barton <marshbarton@wowway.com> - 2011-04-02 15:38 -0500
    Re: Determine what the main form <martin@hotmail.com> - 2011-04-03 10:36 +0200
    Re: Determine what the main form Arsene@selenium.net - 2011-04-03 09:42 -0500
      Re: Determine what the main form Marshall Barton <marshbarton@wowway.com> - 2011-04-03 12:53 -0500
        Re: Determine what the main form Arsene@selenium.net - 2011-04-03 13:01 -0500
          Re: Determine what the main form Marshall Barton <marshbarton@wowway.com> - 2011-04-03 17:23 -0500
            Re: Determine what the main form <martin@hotmail.com> - 2011-04-04 17:00 +0200
              Re: Determine what the main form Marshall Barton <marshbarton@wowway.com> - 2011-04-04 11:33 -0500
            Re: Determine what the main form Arsene@selenium.net - 2011-04-08 09:33 -0500

csiph-web