O
omsoft
I have a form in which the user would select a project id from a combo box. I
have created an afterUpdate event which then runs a query with selected
project id to get data from the table - fields are task, project manager,
start date, end date, etc. These fields are locked so that they can not be
changed. But there are several other fields such as status, role, etc. which
the user would then update. I do this by Me.Requery in that event.
This is a continuous form since each project may have different number of
tasks.
I have two questions.
1. When I open the form, it has data from previous query. How do I
initialize this? I tried to initialize in load event, but that did not work.
DoCmd.OpenForm stDocName, acNormal, , , acFormEdit
when stDocName is form name.
2. The requery seems to update old project id in the table to the one being
queried. How do I prevent that? If I can initialize the form, I guess this
problem may automatically go away.
Any help would be greatly appreciated.
have created an afterUpdate event which then runs a query with selected
project id to get data from the table - fields are task, project manager,
start date, end date, etc. These fields are locked so that they can not be
changed. But there are several other fields such as status, role, etc. which
the user would then update. I do this by Me.Requery in that event.
This is a continuous form since each project may have different number of
tasks.
I have two questions.
1. When I open the form, it has data from previous query. How do I
initialize this? I tried to initialize in load event, but that did not work.
DoCmd.OpenForm stDocName, acNormal, , , acFormEdit
when stDocName is form name.
2. The requery seems to update old project id in the table to the one being
queried. How do I prevent that? If I can initialize the form, I guess this
problem may automatically go away.
Any help would be greatly appreciated.