refresh a form from a different form

[mauriceglynn]

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

[Ecniv]

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).

[nagasrikanth]

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

subform.requery

option...

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

thanx & regards
Anu..

[mauriceglynn]

many thanks

I let you know how I get on...

MG