[AccessD] Calling control (WAS How do I determine which formcalled?)

MessageOh Charlotte, a girl after my own heart!  :-)

John W. Colby
www.colbyconsulting.com

  -----Original Message-----
  From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Charlotte Foust
  Sent: Tuesday, July 01, 2003 11:01 AM
  To: Access Developers discussion and problem solving
  Subject: RE: [AccessD] Calling control (WAS How do I determine which
formcalled?)


  Have you tried raising a custom event from the unbound form and sinking
the event on the form that needs to retrieve the information?

  Charlotte Foust
    -----Original Message-----
    From: Roz Clarke [mailto:roz.clarke at donnslaw.co.uk]
    Sent: Tuesday, July 01, 2003 12:18 AM
    To: 'Access Developers discussion and problem solving'
    Subject: [AccessD] Calling control (WAS How do I determine which form
called?)


    This is interesting. I need to do something sort of similar... I have an
unbound text box on an unbound form which I want to use to display memo
fields that are too small to display all their data in the controls on my
main forms. To get the data out is easy - screen.activecontrol will do it.
But then if they amend the data I need to get the new string back into the
right control on the right form. Trouble is it could be up to 3 layers deep
on subforms and as far as I can tell, to get the data back in I need to
build a full reference to the calling control e.g.
Forms!frmLevel1!frmLevel2.form!frmLevel3.form!ctrlCalling



    Does anyone have an idea of how I could do this when I don't know how
many forms are involved???



    TIA



    Roz



    -----Original Message-----
    From: Charlotte Foust [mailto:cfoust at infostatsystems.com]
    Sent: 30 June 2003 18:13
    To: Access Developers discussion and problem solving
    Subject: RE: [AccessD] How do I determine which form called?



    I make CalledFrom a property of my forms.  Then I can pass the calling
form's name in the OpenArgs string and let the called form populate its own
property.  When I close the called form, it checks its CalledFrom property
and goes back to that.  In 2002 you can do this with Reports as well.



    Charlotte Foust

      -----Original Message-----
      From: Hale, Jim [mailto:jim.hale at fleetpride.com]
      Sent: Monday, June 30, 2003 6:04 AM
      To: 'Access DatabaseAdvisors (E-Mail)'
      Subject: [AccessD] How do I determine which form called?

      Does anyone have a function that will allow a class to determine which
form called it? TIA
      Jim Hale
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030701/36d39c3c/attachment-0001.html>