Welcome to SPN

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

Sign Up Now!
  1. Monthly (Recurring) Target: $300 :: Achieved: $95
      Become a Supporter    ::   Make a Contribution   

select row and display information

Discussion in 'Information Technology' started by Kirt84, Jul 28, 2006.

  1. Kirt84

    Kirt84
    Expand Collapse
    Guest

    I am still a novice user of Access and need some help. I have a Database that
    controls the stock levels within my company. I have created various sections
    to display where current products are within the process. This is displayed
    using a form and the information is displayed on a subform so that the grand
    total of the stock can be displayed.

    I would like to have the function to select a row on the subform and by
    double clicking - open another form (input form) displaying that record. Is
    this possible?

    --
    Thank you for your help
     
  2. Loading...


  3. Larry Daugherty

    Larry Daugherty
    Expand Collapse
    Guest

    You can get that functionality by running your well crafted sub
    procedure ...

    To start, design and name the form you're going to open so that there
    will really be something for your new code to open.

    Then ...

    To start, I recommend that you add a command button to your subform
    that will show on each row titled something like "Show this record".
    You'll change things more to your taste after you get it to work.

    In the Click Event of that command button put your code using

    DoCmd.OpenForm()

    Usually the biggest hurdle is learning how to refer to subforms.
    There is a good explanation on www.mvps.org/access

    Another thing I recommend is that you open the new form in Dialog mode
    so that it will keep the user from fiddling with other parts of your
    application while that form is open.

    HTH
    --
    -Larry-
    --

    "Kirt84" <Kirt84@discussions.microsoft.com> wrote in message
    news:4CCAD188-CF4E-42C2-A3EC-A7375354323E@microsoft.com...
    > I am still a novice user of Access and need some help. I have a

    Database that
    > controls the stock levels within my company. I have created various

    sections
    > to display where current products are within the process. This is

    displayed
    > using a form and the information is displayed on a subform so that

    the grand
    > total of the stock can be displayed.
    >
    > I would like to have the function to select a row on the subform and

    by
    > double clicking - open another form (input form) displaying that

    record. Is
    > this possible?
    >
    > --
    > Thank you for your help
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page