refresh a form from a different form

Hi

An action on a form causes new records to get written which are displayed in a different form in the same db.

After performing the action I navigate to the second form where the records should be displayed and they are not visible. I have to force a system refresh by removing all filters (even though none are active) to make the records visible.

In the code that writes the records I do a me.refresh and have tried me.repaint and even a DoCmd repaintobject (I think that is it).

None of this works - the repaintobject cannot find the second form although it is specified and present in the db!

Any help would be great.

MG

If it is a matter of timing it may be Access's default caching.
Search the forums (top) for 'caching jro refresh'

It could be you need me.requery (try this first).

if the second form is a sub form then u can use

VB Code:

subform.requery

option...

I think this requery option will help for other forms also...please chk it..

thanx & regards
Anu..

many thanks

I let you know how I get on...

MG