Requery

[Dave Eyley]

Has anybody had this problem with Requery?

I have used this so many times in databases and had no problem, but in Access 2010, apart from other buggy issues, the requery won't work properly.

This is what's its doing -

1. Open Main form with subform containg records in continuous form.
2. Clicking on a record in the subform opens a pop-up form with the relevant record for editing.
3. Use either of the requery commands below on the OnClose of the popup form.
Forms!MainForm!MainSub.Form.Requery
Forms!Main!MainSub.Requery
4. The subform doesn't requery.

But if I open the pop up form again and close it immediately without making any changes, it does update the sub form...it seems to take 2 hits to requery...

It's very strange... anybody else had this problem?

 

[RuralGuy]

Have you saved the changes yet? If Me.Dirty Then Me.Dirty = False will do it.

 

[Dave Eyley]

Hi RuralGuy,

Yes, tried that. Had to re-install access to get this to work, in the end. This is the most buggy version of Access I've ever worked on...

Thanks for replying...

Dave

 

[Dave Eyley]

Talking of buggy...has anyone noticed how the text labels don't line up with the text boxes in the 2010 version?