Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    3

    Question Unanswered: Button on one form to open another

    Hello,

    Having searched on here and google for a few hours now, I have given in to posting my question here as this Access dummy is still struggling! I found one post similar here, but the anwser didn't help me.

    I am trying to create a db so simple that even I could do it; but oh no! The db consists of two tables: one to hold my clients basic standard info (name, address etc) "form 1" and another to hold the data from each time we meet "form 2". I understand this is called 'one to many' relationship?? (i.e. I may see the client many times and so in form 2, need multiple records)

    What I am trying to do is create a button on "form 1", that will open a fresh record in "form 2", but will 'carry over' some of the basic info (client ID and name). The only button I have managed to create is one that opens a new record in 'form 1' !!

    Hopefully then when this form 2 is completed and the record saved, it will be linked to the original form 1.

    So questions:
    - How to create such a button
    - Is there a template for such a db? (all the ones I have found are far too much of an overkill and too complex!)

    Thanks for helping.

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,473
    Provided Answers: 10
    On form1 in design Mode

    create a Command botton with the wizard on


    Click
    Form Operation
    open form
    click the form you want to open [form 2]
    then click
    open the form and find specific data to display.
    click feild on right and left then <-> **
    next next

    Done

    ** base on the Jion it will open the form2 only sowing data base on form 1
    hope this help

    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
    DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
    THEY'RE BEHIND YOU FOR A REASON

Posting Permissions

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