Requery problems

  • Thread starter Thread starter Mus' via AccessMonster.com
  • Start date Start date
M

Mus' via AccessMonster.com

Hi

I'm an 'enthusiastic amatuer' and I have a couple of challenges.

Under frmRecords, I have a subfrmInvestments which amongst other things shows
the last recorded value. To update values I have a popup frm. On closing
popfrmInvValues I need the subfrmInvestments latest value field to update.

The challenges I have are thus:
At present, though not great, I simply requery the frmRecords OnClose of
popfrmInvValues. This does the trick on Access2003 with the exception of
going back to the first record not the current. I would prefer it to go back
to the currrent record.

The second issue is that, on Access2000 I get an ApplyFilter error on the
Requery stage of the Macro.

Any assistance appreciated.
 
Back
Top