Results 1 to 11 of 11
  1. #1
    djwhy60 is offline Novice
    Windows 8 Access 2013 64bit
    Join Date
    Feb 2016
    Location
    Lafayette, LA
    Posts
    5

    Moving information from one form to another

    Good Morning,

    I have searched for DAYS to get a simple, to the point answer that many people have, but have yet to find it. I am VERY new to Access 2013 so forgive me if I state some information incorrect. My issues is as follows:

    I have a db that logs and tracks quality information. I have 2 forms developed with information about the quality issues.

    Form #1 = NCR
    Form #2 = EI

    On form #1 I have text and drop downs for information pertaining to the NCR. I also have yes/no check blocks. One of the blocks is labeled EI. What I am trying to do.....if this block is checked yes, move the pertinent information from Form#1 to Form #2.

    Seems like an easy idea....yet I have read countless issues from novices like me, with the same problem. No real answers out there. At least any that a novice can understand! Seems to me that this should be a Macro already. I kind of have a feel for them...but when it gets into VBA, I get a headache! (hope you all see some humor in all of this!)



    Thank you ahead of time for your patients and willingness to help. Have a great day!

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,849
    You know your subject. But for the rest of us reading your post is a little on the "jargony side".

    NCR and EI?

    In a few lines to help orient us, please give us the 30,000 ft overview of what you are trying to accomplish. Use the terminology you would use if someone that you don't know, has no knowledge of database, Access, you or your environment asked you what is the issue.

    Forms are sort of a window for seeing data in tables and queries. Data is stored in tables.

  3. #3
    djwhy60 is offline Novice
    Windows 8 Access 2013 64bit
    Join Date
    Feb 2016
    Location
    Lafayette, LA
    Posts
    5
    I am sorry for being so vague….let me see if I can draw a bigger picture.
    The data base I am working with is a way for our company to log Non-Conforming Reports (NCR) and track information associated with them. Sometime we need to do an Engineering Investigation (EI) that is associated with the NCR.
    I created 2 forms…one to fill out the initial NCR and another just in case there is an EI associated with it.
    The NCR form has the following:
    NCR- auto number block
    Internal-yes/no check box-if yes, message box pop up stating “no vendor required”
    Engineer Investigation-yes/no check box-if yes message box pop up stating “Engineering Investigation will be created”
    Assigned to-drop down with names of personnel
    Open Date-date the NCR was entered
    Part Number- text box for the associated part number
    Vendor-text box for the vendor associated with the part
    Non-Conformance- text box (large) with the description of the problem with the part
    Root Cause-test box (large) for the explanation of the defects reason
    Action- text box (large) for the action taken to remedy the problem
    Closed by-drop down with the names of management
    Closed date-date the NCR was closed
    Closed-yes/no check box-if yes pop up stating “has this action been reviewed and closed”

    The EI form has the following:
    EI-auto number block
    Related NCR-this is the first block of info from the first form I need “NCR-auto number block”
    Date assigned- the date the EI is opened
    Assigned to- drop down with names of personnel
    Part Number- second block of information from the first form I need “Part Number-text box for associated part number”
    Serial Number-text box for the serial number of the part
    Details-thirst block of information from the first form I need “Non-Conformance- text box (large) with the description of the problem with the part”
    I am trying to have the EI form populate the required info (noted above) when the Engineering Investigation” yes/no block is checked.
    I hope this makes things a little clearer….thank you for any assistance ahead of time!

  4. #4
    NTC is offline VIP
    Windows 7 64bit Access 2013
    Join Date
    Nov 2009
    Posts
    2,392
    generically speaking there are 2 approaches to moving data from form 1 to form 2

    a. control name calls: i.e. Forms!Form1Name.ControlName = Forms!Form2Name.ControlName

    b. record sets: write & fire an update or append query

    there is not a right or wrong; it all depends on your user interface experience as to how & when things get triggered.....

  5. #5
    djwhy60 is offline Novice
    Windows 8 Access 2013 64bit
    Join Date
    Feb 2016
    Location
    Lafayette, LA
    Posts
    5
    I appreciate the time to post. But being very new to working with this, I am not sure where to use this information. I am beginning to understand how to work in Macros....even made an attempt to use TempVars to make "this" happen..no luck. So if you could point me in the direction as to where to enter the above....I would appreciate it.

  6. #6
    orange's Avatar
    orange is offline Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,849
    djwhy60,

    I think you would help yourself by working through a database and table design tutorial. I recommend this one from RogersAccessLibrary. You will learn how to go from a description of your requirements to a database structure to support those requirements. You have to work through the tutorial, but you will learn and what you learn can be applied to any database.

    Should take 40-60 minutes. Good luck.

  7. #7
    NTC is offline VIP
    Windows 7 64bit Access 2013
    Join Date
    Nov 2009
    Posts
    2,392
    I should add to my prior post a 3rd method:

    c. Look Up field type - implemented either at the table level or implemented at the form level - where the field of form 1 is looking up (or calling in) data from the table of form 2

    it depends on how one interprets your post and what is the user interface design approach

  8. #8
    djwhy60 is offline Novice
    Windows 8 Access 2013 64bit
    Join Date
    Feb 2016
    Location
    Lafayette, LA
    Posts
    5
    Orange,

    Thank you very much for the direction. I can understand how laying out the data base in a precise manner would make things much easier to work with. Lucky I am just starting to design this data base..from scratch...and I am not that far into the process. And the management just threw in additional requirements. Good place to start over!

  9. #9
    orange's Avatar
    orange is offline Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,849
    You're welcome.
    And for a follow on watch this series of youtube videos by Dr Daniel Soper.
    They start here. Be sure to watch 1,2 and 4 in the series.
    Good luck.

  10. #10
    JamesDeckert is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jul 2015
    Location
    Salina, KS
    Posts
    262
    OpenArgs lets you pass info between forms also.

  11. #11
    djwhy60 is offline Novice
    Windows 8 Access 2013 64bit
    Join Date
    Feb 2016
    Location
    Lafayette, LA
    Posts
    5
    Quote Originally Posted by orange View Post
    You're welcome.
    And for a follow on watch this series of youtube videos by Dr Daniel Soper.
    They start here. Be sure to watch 1,2 and 4 in the series.
    Good luck.

    These are great for us new to databases! I would recommend them to anyone just starting. Just went through the first 2 and found them very helpful! Thank you again!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 05-02-2014, 09:27 AM
  2. Replies: 3
    Last Post: 02-24-2013, 02:32 PM
  3. Moving to new record from a different form
    By liam_898 in forum Forms
    Replies: 12
    Last Post: 05-05-2012, 12:34 PM
  4. Replies: 1
    Last Post: 12-12-2011, 01:58 PM
  5. Moving Information from One Form to Another
    By bsharpbyoung in forum Forms
    Replies: 2
    Last Post: 03-22-2009, 09:37 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums