Field won't update

[gg80]

I have a continuous form that includes a date field. I have some code that opens an append query to append the selected record to a table (AfterUpdate). In the query, the date field to be appended is Forms!Thisform.UpdatedDate.

The problem is that the date field doesn't append on first try. If I update more than once it will append the previously entered date.

Using W7 and A2007. Must be simple, but eludes me. Help appreciated much.

[drexasaurus]

Are you using a saved Append Query created in the visual editor and refering to the query by name?

Are you looking at the data after the query without refreshing it afterwards?

Additional details would be needed for me to give what advice I have.

[gg80]

Thanks for quick response

I am using a created query and referring to it by name.

The query appends to a closed table. I later open the form sourced from the table after the append action and shows old date as described

I have two other fields on the form that do not get updated that append OK

[gg80]

Drexaaurus-sorry to waste your time. I am redfaced to say that that I got copies mixed up and the troublesome field that I was using to append date was sourced to the underlying query, not the form. That was the one that gave me problems. When I changed the date source to the form as described, works fine. I don't understand why the one that doesn't work doesn't work, but onward. Again, sorry. gg80