Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

FORMS: Open New Form, Show data from Previous Employee

Discussion in 'Information Technology' started by franklinbukoski, Nov 8, 2005.

  1. franklinbukoski

    franklinbukoski
    Expand Collapse
    Guest

    I would like to click a button on one form that automatically shows me
    additional data on the same employee I was just looking at in the first form.

    My first form enables me to edit employee data, but sometimes when I update
    their information I need to see every other pending action that is tracked
    against the employee, so when I open the new form I'd like it to display all
    of this associated data, without having to reenter the employee's SSN.
     
  2. Loading...

    Similar Threads Forum Date
    USA Akaal Takhat Forms Committee to Represent US Sikhs Breaking News Sep 13, 2013
    India Poll reforms on crash course Breaking News Sep 7, 2013
    General A Conversation about the Grammatical Forms of Raam and Simran Hard Talk Dec 1, 2011
    India Anna Says Fast Only "Suspended", Wants Electoral Reforms Breaking News Aug 28, 2011
    India India Announces $5 bn Aid for Africa, Seeks Support for UN Reforms Breaking News May 24, 2011

  3. Van T. Dinh

    Van T. Dinh
    Expand Collapse
    Guest

    Use the "wherecondition" argument in the OpenForm method to filter the
    second/called form to only the current employee on the calling form.

    Check Access VB Help on the OpenForm method.

    --
    HTH
    Van T. Dinh
    MVP (Access)



    "franklinbukoski" <franklinbukoski@discussions.microsoft.com> wrote in
    message news:E94A9200-B22C-463C-800E-DA71094CF6C2@microsoft.com...
    >I would like to click a button on one form that automatically shows me
    > additional data on the same employee I was just looking at in the first
    > form.
    >
    > My first form enables me to edit employee data, but sometimes when I
    > update
    > their information I need to see every other pending action that is tracked
    > against the employee, so when I open the new form I'd like it to display
    > all
    > of this associated data, without having to reenter the employee's SSN.
     

Share This Page