(Access 2016) New form- cannot advance record by selector
This might be a bit more complicated than the title lets on. I have done exhaustive searching on this issue and can't find a similar thread.
I have a form (form A). It has a button which, when clicked, opens another form (form B). Form B is opened with DoCmd.OpenForm in Data Entry mode with acFormAdd. In Form B "Allow Additions" is now set to enabled, "Data Entry" is enabled, and "Record Locks" is set to No.
When Form B first loads (new entry) I have some code which populates a few of the controls with data passed through OpenArgs from Form A. This should be enough to constitute a complete record, however I cannot advance to a new record because the arrow at the bottom is grayed out.
Here's the weird part. I CAN advance the record by tabbing all the way through each control to the end. I can also "unlock" the new record arrow by first clicking the last record arrow (just the right of other arrow), then the new record arrow is suddenly enabled. And that arrow is ALWAYS enabled after advancing the first time. So from record 2 onward, there's no issue.
This form is based on a linked table, however I don't think the problem is there- I can add data to that table manually just fine.
I know this isn't a huge issue because I can still use the form. But it still bugs the heck out of me nonetheless. It also would be unintuitive to the end-user who wants to make a new entry, and there are quite a lot of controls to tab through. So what's going on?
selector record new-operator access
asked Nov 15 '18 at 21:34
caryacarya
12
add a comment |
This might be a bit more complicated than the title lets on. I have done exhaustive searching on this issue and can't find a similar thread.
I have a form (form A). It has a button which, when clicked, opens another form (form B). Form B is opened with DoCmd.OpenForm in Data Entry mode with acFormAdd. In Form B "Allow Additions" is now set to enabled, "Data Entry" is enabled, and "Record Locks" is set to No.
When Form B first loads (new entry) I have some code which populates a few of the controls with data passed through OpenArgs from Form A. This should be enough to constitute a complete record, however I cannot advance to a new record because the arrow at the bottom is grayed out.
Here's the weird part. I CAN advance the record by tabbing all the way through each control to the end. I can also "unlock" the new record arrow by first clicking the last record arrow (just the right of other arrow), then the new record arrow is suddenly enabled. And that arrow is ALWAYS enabled after advancing the first time. So from record 2 onward, there's no issue.
This form is based on a linked table, however I don't think the problem is there- I can add data to that table manually just fine.
I know this isn't a huge issue because I can still use the form. But it still bugs the heck out of me nonetheless. It also would be unintuitive to the end-user who wants to make a new entry, and there are quite a lot of controls to tab through. So what's going on?
selector record new-operator access
asked Nov 15 '18 at 21:34
caryacarya
12
add a comment |
This might be a bit more complicated than the title lets on. I have done exhaustive searching on this issue and can't find a similar thread.
I have a form (form A). It has a button which, when clicked, opens another form (form B). Form B is opened with DoCmd.OpenForm in Data Entry mode with acFormAdd. In Form B "Allow Additions" is now set to enabled, "Data Entry" is enabled, and "Record Locks" is set to No.
When Form B first loads (new entry) I have some code which populates a few of the controls with data passed through OpenArgs from Form A. This should be enough to constitute a complete record, however I cannot advance to a new record because the arrow at the bottom is grayed out.
Here's the weird part. I CAN advance the record by tabbing all the way through each control to the end. I can also "unlock" the new record arrow by first clicking the last record arrow (just the right of other arrow), then the new record arrow is suddenly enabled. And that arrow is ALWAYS enabled after advancing the first time. So from record 2 onward, there's no issue.
This form is based on a linked table, however I don't think the problem is there- I can add data to that table manually just fine.
I know this isn't a huge issue because I can still use the form. But it still bugs the heck out of me nonetheless. It also would be unintuitive to the end-user who wants to make a new entry, and there are quite a lot of controls to tab through. So what's going on?
selector record new-operator access
asked Nov 15 '18 at 21:34
caryacarya
12
This might be a bit more complicated than the title lets on. I have done exhaustive searching on this issue and can't find a similar thread.
I have a form (form A). It has a button which, when clicked, opens another form (form B). Form B is opened with DoCmd.OpenForm in Data Entry mode with acFormAdd. In Form B "Allow Additions" is now set to enabled, "Data Entry" is enabled, and "Record Locks" is set to No.
When Form B first loads (new entry) I have some code which populates a few of the controls with data passed through OpenArgs from Form A. This should be enough to constitute a complete record, however I cannot advance to a new record because the arrow at the bottom is grayed out.
Here's the weird part. I CAN advance the record by tabbing all the way through each control to the end. I can also "unlock" the new record arrow by first clicking the last record arrow (just the right of other arrow), then the new record arrow is suddenly enabled. And that arrow is ALWAYS enabled after advancing the first time. So from record 2 onward, there's no issue.
This form is based on a linked table, however I don't think the problem is there- I can add data to that table manually just fine.
I know this isn't a huge issue because I can still use the form. But it still bugs the heck out of me nonetheless. It also would be unintuitive to the end-user who wants to make a new entry, and there are quite a lot of controls to tab through. So what's going on?
selector record new-operator access
selector record new-operator access
asked Nov 15 '18 at 21:34
caryacarya
12
asked Nov 15 '18 at 21:34
caryacarya
12
edited Nov 15 '18 at 21:47
carya
asked Nov 15 '18 at 21:34
caryacarya
12
asked Nov 15 '18 at 21:34
caryacarya
12
asked Nov 15 '18 at 21:34
caryacarya
12
12
add a comment |
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%2f53328232%2faccess-2016-new-form-cannot-advance-record-by-selector%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%2f53328232%2faccess-2016-new-form-cannot-advance-record-by-selector%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
