Styjun

Examples of fluid (including air) being used to transmit digital data?

What purpose does mercury dichloride have in fireworks?

Which is a better conductor, a very thick rubber wire or a very thin copper wire?

Why did RFK loathe LBJ?

Ways to demonstrate ("show-off") contributions as an undergraduate in research

How do I talk to my wife about unrealistic expectations?

What's the difference between a type and a kind?

Interpretation of non-significant results as "trends"

Diagram with cylinder shapes and rectangles

Why am I getting unevenly-spread results when using $RANDOM?

Tesco's Burger Relish Best Before End date number

What exactly is a "murder hobo"?

What are some bad ways to subvert tropes?

Function that detects repetitions

The flying colours

Was the 45.9°C temperature in France in June 2019 the highest ever recorded in France?

In layman's terms, does the Luckstone just give a passive +1 to all d20 rolls and saves except for death saves?

What is the shape of the upper boundary of water hitting a screen?

Computer name naming convention for security

Uniform initialization by tuple

Sense of humor in your sci-fi stories

What does the multimeter dial do internally?

Where are the Wazirs?

Is it acceptable that I plot a time-series figure with years increasing from right to left?

How to open a second form based on another completed form's ID?

How to list the tables in a SQLite database file that was opened with ATTACH?How to prevent buttons from submitting formsSubforms integration not working seamlessly in Ms Access 2010Access data entry with subformsSubform data not updating tableOpen a Form with ID MS AccessAuto Populate Control on a form with value of the control on another formRefreshing a Subform after a record is added on another formHow to select a subform record and display in a popup mainformLinked forms won't update data in table

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

[Access 2010]

I am trying to link a form based on an initial form's unique ID (auto-generated string value). Here's a simple outline of database design:

Relevant Tables:

1. tblCruiseLog (CruiseLogID is primary key)




2. tblMasterStation (has MasterStationID field as primary key, with CruiseLogID field as foreign key)

Relevant Forms:

1. CruiseLog




2. MasterStation

Expected workflow:

1. Open CruiseLog, auto-generate CruiseLogID, fill out some fields (no issues).




2. Close CruiseLog form, go back to main switchboard, and open MasterStation form (no issues).




3. MasterStation form loads, creates a new record with an auto-generated MasterStationID, and auto-fills CruiseLogID with the CruiseLogID that was generated in Step 1 (???).

I am having trouble figuring out how to get the MasterStation form to carry over the CruiseLogID that was created in workflow step 1. Making the MasterStation a subform within the CruiseLog form is not possible, because the MasterStation form itself will have a subform within it. How can I accomplish this?

Thank you.

database forms ms-access ms-access-2010

share|improve this question

asked Mar 25 at 21:02

C. LarsenC. Larsen

111 bronze badge

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Why not use form/subform arrangement? Otherwise, code in CruiseLog sets a global variable or a TempVars variable that can be referenced by MasterStation.
  
  – June7
  Mar 25 at 21:27
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I can't make it a subform because MasterStation itself has a subform within it. I want to fill out the CruiseLog, close it, and then continue to reference it with each successive MasterStation record. The CruiseLog info only gets filled out once at the beginning of the day, whereas MasterStation/subforms get filled out repeatedly at each new sampling station. I'm not sure how to set a global variable
  
  – C. Larsen
  Mar 25 at 21:43
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Do some research. I have given you topics to investigate. There are many examples. Maybe you can use form/subform/subsubform. Another approach to consider is demonstrated in fmsinc.com/MicrosoftAccess/Forms/Synchronize/LinkedSubforms.asp.
  
  – June7
  Mar 25 at 21:49
  
  

  
  
  
  

add a comment | 

0

[Access 2010]

I am trying to link a form based on an initial form's unique ID (auto-generated string value). Here's a simple outline of database design:

Relevant Tables:

1. tblCruiseLog (CruiseLogID is primary key)




2. tblMasterStation (has MasterStationID field as primary key, with CruiseLogID field as foreign key)

Relevant Forms:

1. CruiseLog




2. MasterStation

Expected workflow:

1. Open CruiseLog, auto-generate CruiseLogID, fill out some fields (no issues).




2. Close CruiseLog form, go back to main switchboard, and open MasterStation form (no issues).




3. MasterStation form loads, creates a new record with an auto-generated MasterStationID, and auto-fills CruiseLogID with the CruiseLogID that was generated in Step 1 (???).

I am having trouble figuring out how to get the MasterStation form to carry over the CruiseLogID that was created in workflow step 1. Making the MasterStation a subform within the CruiseLog form is not possible, because the MasterStation form itself will have a subform within it. How can I accomplish this?

Thank you.

database forms ms-access ms-access-2010

share|improve this question

asked Mar 25 at 21:02

C. LarsenC. Larsen

111 bronze badge

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Why not use form/subform arrangement? Otherwise, code in CruiseLog sets a global variable or a TempVars variable that can be referenced by MasterStation.
  
  – June7
  Mar 25 at 21:27
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I can't make it a subform because MasterStation itself has a subform within it. I want to fill out the CruiseLog, close it, and then continue to reference it with each successive MasterStation record. The CruiseLog info only gets filled out once at the beginning of the day, whereas MasterStation/subforms get filled out repeatedly at each new sampling station. I'm not sure how to set a global variable
  
  – C. Larsen
  Mar 25 at 21:43
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Do some research. I have given you topics to investigate. There are many examples. Maybe you can use form/subform/subsubform. Another approach to consider is demonstrated in fmsinc.com/MicrosoftAccess/Forms/Synchronize/LinkedSubforms.asp.
  
  – June7
  Mar 25 at 21:49
  
  

  
  
  
  

add a comment | 

[Access 2010]

I am trying to link a form based on an initial form's unique ID (auto-generated string value). Here's a simple outline of database design:

Relevant Tables:

1. tblCruiseLog (CruiseLogID is primary key)




2. tblMasterStation (has MasterStationID field as primary key, with CruiseLogID field as foreign key)

Relevant Forms:

1. CruiseLog




2. MasterStation

Expected workflow:

1. Open CruiseLog, auto-generate CruiseLogID, fill out some fields (no issues).




2. Close CruiseLog form, go back to main switchboard, and open MasterStation form (no issues).




3. MasterStation form loads, creates a new record with an auto-generated MasterStationID, and auto-fills CruiseLogID with the CruiseLogID that was generated in Step 1 (???).

I am having trouble figuring out how to get the MasterStation form to carry over the CruiseLogID that was created in workflow step 1. Making the MasterStation a subform within the CruiseLog form is not possible, because the MasterStation form itself will have a subform within it. How can I accomplish this?

Thank you.

database forms ms-access ms-access-2010

share|improve this question

asked Mar 25 at 21:02

C. LarsenC. Larsen

111 bronze badge

share|improve this question

asked Mar 25 at 21:02

C. LarsenC. Larsen

111 bronze badge

share|improve this question

asked Mar 25 at 21:02

C. LarsenC. Larsen

111 bronze badge

asked Mar 25 at 21:02

C. LarsenC. Larsen

111 bronze badge

asked Mar 25 at 21:02

C. LarsenC. Larsen

111 bronze badge