Moving information from one form to another

[djwhy60]

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!

[orange]

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.

[djwhy60]

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!

[NTC]

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.....

[djwhy60]

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.

[orange]

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.

[NTC]

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

[djwhy60]

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!

[orange]

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.

[JamesDeckert]

OpenArgs lets you pass info between forms also.

[djwhy60]

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!