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

    Question Unanswered: Button on one form to open another


    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
    New Zealand
    Provided Answers: 10
    On form1 in design Mode

    create a Command botton with the wizard on

    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


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

    See clear as mud

    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 based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008

Posting Permissions

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