Append Queries and Order of Events

[Coolboy55]

I have an append query that runs in the AfterUpdate event of my DateCompletedBy textbox. DateCompletedBy is one of the fields I'm appending. For some reason, all other fields work fine, but DateCompletedBy appends blank. I'm assuming that this has something to do with the order of events. So the question is: At which event does the entered data become the current value for a textbox?

Thanks!

CB55

[Coolboy55]

Poor phrasing on the question. Rephrased: At which event does the entered data get copied to its control source?

[NeoPa]

The AfterUpdate should certainly work for you CB.

Try putting the following code just before your append query is executed within your AfterUpdate procedure.

Call MsgBox(DateCompletedBy)