Multiple Forms to populate a single record access 2016
I am using MS Access 2016 in an attempt to create a Form-driven database.
Suppose I have 2 forms - enter data into several Text Box's on Form One, then another form where user can keep updating/changing the record over time to update current status for only specific fields.
The problem I am facing is that data entered into Form One is placed in Record 1 on my Table, while data entered into Form Two is placed in the next Record (Record 2).
Question: How can I create a string of Forms, but have the data inputted into each of those Forms show up on the same Record in the same Table?
e.g. Form 1 has following fields
Name
Date
Style of Cause
Court File number
Status: "Open", "Close", "Re-Open"
Action Required
File Closure Summary
(and more 39 relevant fields)
Form 2 (I need to update the same record for only selected fields )
Status: "Open", "Close", Re-Open"
Current Status Summary
Status Summary
File Closure Date
File Closure summary
Action Required
Key Lessons Learned
ms-access
edited Nov 21 '18 at 19:00
June7
5,48651227
asked Nov 21 '18 at 15:36
Ankita ZaveriAnkita Zaveri
385
add a comment |
I am using MS Access 2016 in an attempt to create a Form-driven database.
Suppose I have 2 forms - enter data into several Text Box's on Form One, then another form where user can keep updating/changing the record over time to update current status for only specific fields.
The problem I am facing is that data entered into Form One is placed in Record 1 on my Table, while data entered into Form Two is placed in the next Record (Record 2).
Question: How can I create a string of Forms, but have the data inputted into each of those Forms show up on the same Record in the same Table?
e.g. Form 1 has following fields
Name
Date
Style of Cause
Court File number
Status: "Open", "Close", "Re-Open"
Action Required
File Closure Summary
(and more 39 relevant fields)
Form 2 (I need to update the same record for only selected fields )
Status: "Open", "Close", Re-Open"
Current Status Summary
Status Summary
File Closure Date
File Closure summary
Action Required
Key Lessons Learned
ms-access
edited Nov 21 '18 at 19:00
June7
5,48651227
asked Nov 21 '18 at 15:36
Ankita ZaveriAnkita Zaveri
385
1
Open the next form using the ID of the first.
– Gustav
Nov 21 '18 at 15:49
Instead of complication of multiple forms, maybe a single form with a Tab control? Name and Date are reserved words. Advise not to use reserved words as names as well as no spaces nor punctuation/special characters (underscore only exception).
– June7
Nov 21 '18 at 18:58
add a comment |
I am using MS Access 2016 in an attempt to create a Form-driven database.
Suppose I have 2 forms - enter data into several Text Box's on Form One, then another form where user can keep updating/changing the record over time to update current status for only specific fields.
The problem I am facing is that data entered into Form One is placed in Record 1 on my Table, while data entered into Form Two is placed in the next Record (Record 2).
Question: How can I create a string of Forms, but have the data inputted into each of those Forms show up on the same Record in the same Table?
e.g. Form 1 has following fields
Name
Date
Style of Cause
Court File number
Status: "Open", "Close", "Re-Open"
Action Required
File Closure Summary
(and more 39 relevant fields)
Form 2 (I need to update the same record for only selected fields )
Status: "Open", "Close", Re-Open"
Current Status Summary
Status Summary
File Closure Date
File Closure summary
Action Required
Key Lessons Learned
ms-access
edited Nov 21 '18 at 19:00
June7
5,48651227
asked Nov 21 '18 at 15:36
Ankita ZaveriAnkita Zaveri
385
I am using MS Access 2016 in an attempt to create a Form-driven database.
Suppose I have 2 forms - enter data into several Text Box's on Form One, then another form where user can keep updating/changing the record over time to update current status for only specific fields.
The problem I am facing is that data entered into Form One is placed in Record 1 on my Table, while data entered into Form Two is placed in the next Record (Record 2).
Question: How can I create a string of Forms, but have the data inputted into each of those Forms show up on the same Record in the same Table?
e.g. Form 1 has following fields
Name
Date
Style of Cause
Court File number
Status: "Open", "Close", "Re-Open"
Action Required
File Closure Summary
(and more 39 relevant fields)
Form 2 (I need to update the same record for only selected fields )
Status: "Open", "Close", Re-Open"
Current Status Summary
Status Summary
File Closure Date
File Closure summary
Action Required
Key Lessons Learned
ms-access
ms-access
edited Nov 21 '18 at 19:00
June7
5,48651227
asked Nov 21 '18 at 15:36
Ankita ZaveriAnkita Zaveri
385
edited Nov 21 '18 at 19:00
June7
5,48651227
asked Nov 21 '18 at 15:36
Ankita ZaveriAnkita Zaveri
385
edited Nov 21 '18 at 19:00
June7
5,48651227
edited Nov 21 '18 at 19:00
June7
5,48651227
edited Nov 21 '18 at 19:00
June7
5,48651227
5,48651227
asked Nov 21 '18 at 15:36
Ankita ZaveriAnkita Zaveri
385
asked Nov 21 '18 at 15:36
Ankita ZaveriAnkita Zaveri
385
asked Nov 21 '18 at 15:36
Ankita ZaveriAnkita Zaveri
385
385
1
Open the next form using the ID of the first.
– Gustav
Nov 21 '18 at 15:49
Instead of complication of multiple forms, maybe a single form with a Tab control? Name and Date are reserved words. Advise not to use reserved words as names as well as no spaces nor punctuation/special characters (underscore only exception).
– June7
Nov 21 '18 at 18:58
add a comment |
1
Open the next form using the ID of the first.
– Gustav
Nov 21 '18 at 15:49
Instead of complication of multiple forms, maybe a single form with a Tab control? Name and Date are reserved words. Advise not to use reserved words as names as well as no spaces nor punctuation/special characters (underscore only exception).
– June7
Nov 21 '18 at 18:58
1
1
Open the next form using the ID of the first.
– Gustav
Nov 21 '18 at 15:49
Open the next form using the ID of the first.
– Gustav
Nov 21 '18 at 15:49
Instead of complication of multiple forms, maybe a single form with a Tab control? Name and Date are reserved words. Advise not to use reserved words as names as well as no spaces nor punctuation/special characters (underscore only exception).
– June7
Nov 21 '18 at 18:58
Instead of complication of multiple forms, maybe a single form with a Tab control? Name and Date are reserved words. Advise not to use reserved words as names as well as no spaces nor punctuation/special characters (underscore only exception).
– June7
Nov 21 '18 at 18:58
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53415534%2fmultiple-forms-to-populate-a-single-record-access-2016%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53415534%2fmultiple-forms-to-populate-a-single-record-access-2016%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
Open the next form using the ID of the first.
– Gustav
Nov 21 '18 at 15:49
Instead of complication of multiple forms, maybe a single form with a Tab control? Name and Date are reserved words. Advise not to use reserved words as names as well as no spaces nor punctuation/special characters (underscore only exception).
– June7
Nov 21 '18 at 18:58