Groups | Search | Server Info | Login | Register

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

Re: Determine what the main form

Show all headers | View raw

On Sun, 03 Apr 2011 17:23:44 -0500, Marshall Barton
<marshbarton@wowway.com> wrote:

>Arsene@selenium.net wrote:
>
>>On Sun, 03 Apr 2011 12:53:32 -0500, Marshall Barton
>><marshbarton@wowway.com> wrote:
>>
>>>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.
>>
>>I have always created separate, dedicated subforms for each mainform,
>>which has thus far worked OK, witht he only drawback it sometimes (in
>>larger applications) results in the creation of a lot of forms, which
>>I was trying to avoid (as one of several ways to decrease file size),
>>but perhaps you are right and it might not be worth it for the
>>relatively minuscule decrease in file size.
>>
>
>File size is not a significant tradeoff factor.  I think the
>major consideration is the maintence confusion of dealing
>with several nearly identical form objects vs the difficulty
>of keeping things straight in one complex form object.  All
>I'm saying is that it is something to think about.

I agree. The minuscule decrease in file size is not worth (in my
particular case) the addedd complexity of the subform. I'll stick to
having simpler, dedicated subforms for each of my main forms, however,
I do like knowing I have a choice, something I did not before.

Back to comp.databases.ms-access | Previous | Next — Previous 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