Using append query after entering new record

[prof.fred]

The program I am working with has an option to add a new record to another table using a button. Not all the records, even new ones, need to be appended.
The append query works fine in all situations but one--when a new record is entered and saved, the append query button returns 0 records to be appended. However, if you go to a different record and come back to the one just added in the main table, the append query works fine. The query uses a TempVar to select only the record being seen at the time. The TempVar is declared prior to attempting to append the record to the other table.

Is there a way to make a just entered record act like its been around for a bit (well at least to save it by changing record to another and back)?

 

[bob fitz]

Is there a way to make a just entered record act like its been around for a bit (well at least to save it by changing record to another and back)?

You can save the current record by using:

Me.Dirty = False

 

[prof.fred]

I had added a save record previously which did not fix the issue. But as I started this thread and commented that the TempVar was declared prior to the append I went back and checked only to find out all the TempVar were cleared prior to the append and not redeclared. By doing so the append worked correctly. My fault. Thank you for your response, it was one step that I hadn't completed previously.

My father used to 'help' me with my 'new math' in primary school by having me explain the problem in depth and in the process I would solve it. I guess the opportunity for this technique never ends.