S
Stacy
I'm pretty new to this access thing and have been having one heck of a
time with it.
Right now, my dilemma (which I've scanned all the archives and can't
find an solution for) is that I have multiple tables, from which I need
to pull information to display on a form, which the user will then
complete two additional fields on, and when the form is submitted,
those two fields need to be updated for the associated record (based on
pulled info on the form) in one of the tables.
To detail, I have two tables: tblIssue and tblProject.
tblIssue contains the fields I_ID (primary key/autonumber), P_ID
(primary key of tblProject/autonumber), I_DESC (memo), I_CLOSED_REASON
(drop down w/ options "Accepted/Completed" or "Rejected"), and I_CLOSED
(yes/no checkbox).
tblProject contains the fields P_ID (primary key/autonumber), P_NAME
(text)
In the form, frmIssueClose, I need the controls to be displayed as
follows:
Issue Number: [I_ID] (combo box, which provides a list of the existing
I_ID numbers from tblIssue)
Project Name: [P_NAME], to be pulled and automatically displayed in a
hidden text box from tblProject, based on the P_ID field that matches
the P_ID field from tblIssue that's associated with the I_ID that's
selected in the Issue Number combo box - non-updateable
Issue Description: [I_DESC], to be pulled and automatically displayed
in a hidden text/memo box from tblIssue, based on the I_ID that's
selected in the Issue Number combo box - non-updateable
Issue Result: [I_CLOSED_RESULT], a combo box that's limited to list,
which the user will update with either "Approved/Completed" or
"Rejected"
Click here to confirm that this issue will be closed. The issue will
not be closed if this box is not checked: [I_CLOSED], a yes/no checkbox
that the user will either check to have the issue labelled as "closed".
When the form is submitted, the last two fields - I_CLOSED_RESULT and
I_CLOSED both need to send their information to the tblIssue record
designated by I_ID and update their respective fields with whatever
information was input into those fields on the form.
However, if I click "Close Issue", it closes the form without saving
those two fields. In every other form I've made, the forms close and
save the information. I tried changing the button to a DoCmd.Save
function instead of a doCmd.Close, but it didn't make any difference,
the form is not submitting the information to the table. I looked into
the idea of launching an append or update querty with an onClick of the
"Close Issue" button, but neither type of query seems to be designed
for modifying single records.
Any suggestions would be enormously helpful!!
time with it.
Right now, my dilemma (which I've scanned all the archives and can't
find an solution for) is that I have multiple tables, from which I need
to pull information to display on a form, which the user will then
complete two additional fields on, and when the form is submitted,
those two fields need to be updated for the associated record (based on
pulled info on the form) in one of the tables.
To detail, I have two tables: tblIssue and tblProject.
tblIssue contains the fields I_ID (primary key/autonumber), P_ID
(primary key of tblProject/autonumber), I_DESC (memo), I_CLOSED_REASON
(drop down w/ options "Accepted/Completed" or "Rejected"), and I_CLOSED
(yes/no checkbox).
tblProject contains the fields P_ID (primary key/autonumber), P_NAME
(text)
In the form, frmIssueClose, I need the controls to be displayed as
follows:
Issue Number: [I_ID] (combo box, which provides a list of the existing
I_ID numbers from tblIssue)
Project Name: [P_NAME], to be pulled and automatically displayed in a
hidden text box from tblProject, based on the P_ID field that matches
the P_ID field from tblIssue that's associated with the I_ID that's
selected in the Issue Number combo box - non-updateable
Issue Description: [I_DESC], to be pulled and automatically displayed
in a hidden text/memo box from tblIssue, based on the I_ID that's
selected in the Issue Number combo box - non-updateable
Issue Result: [I_CLOSED_RESULT], a combo box that's limited to list,
which the user will update with either "Approved/Completed" or
"Rejected"
Click here to confirm that this issue will be closed. The issue will
not be closed if this box is not checked: [I_CLOSED], a yes/no checkbox
that the user will either check to have the issue labelled as "closed".
When the form is submitted, the last two fields - I_CLOSED_RESULT and
I_CLOSED both need to send their information to the tblIssue record
designated by I_ID and update their respective fields with whatever
information was input into those fields on the form.
However, if I click "Close Issue", it closes the form without saving
those two fields. In every other form I've made, the forms close and
save the information. I tried changing the button to a DoCmd.Save
function instead of a doCmd.Close, but it didn't make any difference,
the form is not submitting the information to the table. I looked into
the idea of launching an append or update querty with an onClick of the
"Close Issue" button, but neither type of query seems to be designed
for modifying single records.
Any suggestions would be enormously helpful!!