Updating Data Using a Form

  • Thread starter Thread starter Dwight
  • Start date Start date
D

Dwight

I have a form that has a command button that, when
clicked, changes the active status of a position. On the
form I also have a textbox for remarks. When the button
is clicked I want to ask the user if he/she needs to
update the remarks. If he answers "Yes" then another form
opens with the text that is currently in the remarks. He
can make his changes and click ok.

The problem I am having is there are additional lines of
code within the "on click" routine of the command button.
The additional code is for updating a history table. That
code runs before I have an opportunity to make the changes
to the remarks. Is there a way to make the routine wait
until the other form is closed? Or is there an easier way
to go about this?

Thanks in advance!

Dwight
 
Dwight said:
I have a form that has a command button that, when
clicked, changes the active status of a position. On the
form I also have a textbox for remarks. When the button
is clicked I want to ask the user if he/she needs to
update the remarks. If he answers "Yes" then another form
opens with the text that is currently in the remarks. He
can make his changes and click ok.

The problem I am having is there are additional lines of
code within the "on click" routine of the command button.
The additional code is for updating a history table. That
code runs before I have an opportunity to make the changes
to the remarks. Is there a way to make the routine wait
until the other form is closed? Or is there an easier way
to go about this?
Click to expand...

Open the form using the optional acDialog argument. Then your calling code
will pause until that form is either closed or hidden.
 
Back
Top