Updating main form on form that has a subform

[Juicejam]

My main form uses data from a query and I run a macro with the gotorecord command to go to a specific record in the query thereby displaying the appropriate record. The query runs on a time event as the data in the underlying table changes often. The subform is linked using child properties and I have no problem with syncing the data from the query with the data in the subform.



My problem comes when data in the underlying table changes. I cannot seem to get the main form to refresh whatsoever unless I close the form and reopen again. I've tried the requery and repaintobject commands.

If anyone can help it would be a merry christmas... tks...

[June7]

Show the time event code. Where have you tried the requery command?

[Juicejam]

I am running a macro. The macro commands are as follows:
Requery
GoToRecord
Requery

This runs at 1009 timer event.

Thanks very much for your help

[June7]

I have never used timer events. Could you explain how you set this up and/or provide your project for analysis.

[Rainlover]

Add a Message Box somewhere in your Macro just to see that it is working as you expect.

If it does can you test on a XP Machine. It may be a problem with Vista. I have experienced problems with Win 7 that do not happen in XP.

[Juicejam]

ok, got it to work. I converted the macro to code but I also had to add an extra line of code:
me.recordsource=me.recordsource

Apparently there is a bug in Access 2003 when using subforms (a post from another board). The code forces the query to refresh and voila!!!

Thanks for all the help...