Append Data from new record in existing form

[tcheck]

I have a database where I need to append part of a new record to another table. But when I open the query with the link to the form that is open I cannot see the added record until it's saved to the open form. I tried to re-query the key ID field but that does not work. How do I do a re-query without the form requiring everything and then I am on the incorrect record? Hope this makes sense. Thanks in advance.

[Bob Fitz]

Not sure why you need to requery the form. To save new or edited values use:

If Me.Dirty =True Then
  Me.Dirty = False
End If

[tcheck]

Thanks Bob, that was it. I pur the command in the after update on the last field that will trigger if the data needs to be copied. Is there a better place to put it like in the form on current?

[Bob Fitz]

Thanks Bob, that was it. I pur the command in the after update on the last field that will trigger if the data needs to be copied. Is there a better place to put it like in the form on current?

I don't think so. Certainly no good in the forms On Current event because that fires before any changes are made to data, unless of course, you have other code in the On Current event that changes data.