Query intermittantly not populating 1

[ajking]

I hope the following makes sense.
I have set up a query that is populated from a record that uses six tables, all linked to the main record number. This works fine and I can see all the data required but occasionally it does not populate.
I have to move away from the record, open the query and this time it populates; if I go back to the original record and open the query, this time it populates.
Spooky or what
Am I missing something simple? TIA

'Life is what happens to you while you are busy making other plans' John W. Lennon 1940-1980

 

[dhookom]

have to move away from the record" where are you, in a form or datasheet or code or what? If you are in a form, your record doesn't actually save until either you tell it to save or you move off the record.

Duane MS Access MVP

 

[ajking]

Hi Duane
Sorry for the delay getting back but I have just returned from leave.
following on from your reply I added a save routine when I selected the report button and it worked. I will put it down to the 'friday afternoon before a holiday' brain drain
I should have known better!
Many thanks



'Life is what happens to you while you are busy making other plans' John W. Lennon 1940-1980