Results 1 to 7 of 7
  1. #1
    Join Date
    Jun 2014
    Posts
    12

    Unanswered: Returning name of Active form

    I am using Navigation forms in my application. I would like to reference the current caption of the active navigation window regardless of which screen the user is on. without having to reference the full path of Form![Parent form name]![navigation].[form].caption so that I can populate another screen with the navigation form caption property.

    Any help would greatly be appreciated.

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    496
    Provided Answers: 24
    me.caption

  3. #3
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    My first thought was the same as ranman256's, you'd use Me.Caption, but I'm confused by this:

    Quote Originally Posted by Leenie View Post

    ...I would like to reference the current caption of the active navigation window regardless of which screen the user is on...
    Wouldn't the 'screen the user is on' be the 'active navigation window?'

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  4. #4
    Join Date
    Jun 2014
    Posts
    12
    I have a button on the nav window that opens a form where the user can send me an email describing any issues they are having. Its on this form I need to return the caption property of the sub form showing on the nav window

  5. #5
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    what you could do is declare a global variable (in a code module
    the every time you open a form(or activate it) set that vvariable with the name of the form by assigning the me.caption to the variable.

    alternatively if its a user informing you of a problem you don't neccesarily know where the problem is. historically in these situations I put the form & report name in the same place on the screen so the users get familar with where it is
    I'd rather be riding on the Tiger 800 or the Norton

  6. #6
    Join Date
    Apr 2004
    Location
    Derbyshire, UK
    Posts
    789
    Provided Answers: 1
    Hi

    How about

    Forms(Application.CurrentObjectName).Caption

    ??

    MTB

  7. #7
    Join Date
    Jun 2014
    Posts
    12
    MikeTheBike that worked great Thank you so much!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •