After Update Events

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with some text boxes, I need to append to another table when a specific value is in the text box,
(I already have the append query working) my problem is that before the table (the one that the form is getting the data from) updates the actual value from the text box my update query is executed (the update query depends on the value in the text box), in other words I need to update the original table (with the value from the text box) before a run the update query.

Any suggestions?
 
JT said:
I have a form with some text boxes, I need to append to another table when a specific value is in the text box,
(I already have the append query working) my problem is that before the table (the one that the form is getting the data from) updates the actual value from the text box my update query is executed (the update query depends on the value in the text box), in other words I need to update the original table (with the value from the text box) before a run the update query.
Click to expand...


Force the form to save the record before running the query.

If Me.Dirty Then Me.Dirty = False

However this sounds rather unusual to me (a violation of
normalization??). What are you going to do if the users
change their mind and edit that to a different value???
 
Back
Top