Requery no working consistently

[superchrisdub]

Hi,

I am having problems with requery not working on forms. Sometimes it works and sometimes it doesn't. I have tried to see a pattern to when it does not work but cannot. It is driving me nuts. I am reasonably new to Access vba but am an experienced programmer. The situation is, the following:
I have a form (Form A) based on a query which reads info from 2 linked tables. On Form A I have a calls Form B which deletes a record from one of the underlying tables. After Form B closes itself, I do me.requery. Sometimes it works and sometimes it doesn't. Other factors that may influence things: The Main form reads the query in snapshot mode, Additions and Deletions are not allowed (basically it is read-only form). The query uses DISTINCT to pick up a Client_ID.

Also, I have other read-only forms (see above) that call forms that add records to tables. I have the same problem with requery on those.

Any help would be much appreciated.

Thanks,
Chris

 

[JHB]

Post your database with sample data, (zip it because you haven't post 10 post jet), + description how to reproduce the problem and how to check it!