L
LeAnne
Please help! I am at the end of my rope trying to accomplish what it seems to
me should be a fairly simple task. I won't say my job is hanging in the
balance, but I am under intense pressure to resolve this.
In my database (Candidate Project Evaluation), ProjectSites have a 1:m
relationship with Projects. I have a form, EnterNewProjects, which is the
Main data entry form and contains project site info. The site info is
filtered based on location (selected in a previous form). The subform,
ProjectEval, is used to enter project information for a site, including
Project Number (a unique alphanumeric ID assigned by the user). The
parent/child field is Site_ID. There is also a sub-subform,
sfrmProjectSurvey, in sfrmProjectEval (parent/child field Proj_ID), which is
invisible & disabled until the user enters a Project Number and clicks a
control button on sfrmProjectEval; this runs an append query to "load"
multiple survey questions for the project and makes the sub-subform visible
(& enabled). The user is supposed to complete the data entry process in its
entirety (enter site data/click ctrl on main form to make sfrm visible/enter
data on subform/click ctrl on sfrm to load questions/make sub-subform
visible/take survey) before moving on. I have a series of buttons at the
bottom of the MAIN form to enable the user to enter another site for the same
location (new record on MAIN form), enter another project for the same site
in the same location (new record on SUBFORM), or exit the data entry form.
Everything is working correctly EXCEPT for the "Enter another Project for
this Site" (new record on SUBFORM) button. I've tried
Me!sfrmProjectEval.Requery. I've also tried
DoCmd.GoToControl "sfrmProjectEval"
DoCmd.GoToRecord , , acNewRec
....plus several other variations, to no avail. sfrmProjectEval is based on
an updateable query, and AllowAdditions is set to Yes. The navigation buttons
on sfrm ProjectEval are hidden to force users to complete the entire data
entry process before attempting to enter a new project. However, if I unhide
them, they are not greyed out, so I should be able to enter a new project. I
just can't seem to find the right code to accomplish this.
Any assistance would be GREATLY appreciated!!
LeAnne Astin
Ecologist
Fairfax Coutny Stormwater Planning
me should be a fairly simple task. I won't say my job is hanging in the
balance, but I am under intense pressure to resolve this.
In my database (Candidate Project Evaluation), ProjectSites have a 1:m
relationship with Projects. I have a form, EnterNewProjects, which is the
Main data entry form and contains project site info. The site info is
filtered based on location (selected in a previous form). The subform,
ProjectEval, is used to enter project information for a site, including
Project Number (a unique alphanumeric ID assigned by the user). The
parent/child field is Site_ID. There is also a sub-subform,
sfrmProjectSurvey, in sfrmProjectEval (parent/child field Proj_ID), which is
invisible & disabled until the user enters a Project Number and clicks a
control button on sfrmProjectEval; this runs an append query to "load"
multiple survey questions for the project and makes the sub-subform visible
(& enabled). The user is supposed to complete the data entry process in its
entirety (enter site data/click ctrl on main form to make sfrm visible/enter
data on subform/click ctrl on sfrm to load questions/make sub-subform
visible/take survey) before moving on. I have a series of buttons at the
bottom of the MAIN form to enable the user to enter another site for the same
location (new record on MAIN form), enter another project for the same site
in the same location (new record on SUBFORM), or exit the data entry form.
Everything is working correctly EXCEPT for the "Enter another Project for
this Site" (new record on SUBFORM) button. I've tried
Me!sfrmProjectEval.Requery. I've also tried
DoCmd.GoToControl "sfrmProjectEval"
DoCmd.GoToRecord , , acNewRec
....plus several other variations, to no avail. sfrmProjectEval is based on
an updateable query, and AllowAdditions is set to Yes. The navigation buttons
on sfrm ProjectEval are hidden to force users to complete the entire data
entry process before attempting to enter a new project. However, if I unhide
them, they are not greyed out, so I should be able to enter a new project. I
just can't seem to find the right code to accomplish this.
Any assistance would be GREATLY appreciated!!
LeAnne Astin
Ecologist
Fairfax Coutny Stormwater Planning