combining selective data from 4 calender tables in access in one result per day

[LtdLUk]

Just tried that, not working, only when I press F5, it gets the data.

[LtdLUk]

Private Sub Form_Activate()
Me.Requery
End Sub

[aytee111]

Did you wait for the required time?

Put a debug stop on the Me.Requery line and see if it is executing.

[LtdLUk]

Yes I did, I had put the timer on 30000 which is half a minute. how do I put a debut stop on the me.requery?

[aytee111]

In the VBA editor, click on the left margin of the Me.Requery line, it will put a brown dot there. Then when the event runs it will stop there. The f5 will continue afterwards.

[LtdLUk]

weird, brown dot in place, but the refresh not happening

[aytee111]

Let's start again - form properties, OnTimer Event Procedure, timer interval 30000. Close the form, save it, reopen it.

[LtdLUk]

I've done that.

[LtdLUk]

LEts be clear that the form has a query on it;.. don't konw if it matters... perhaps we need to focus on the query instead the form?

[aytee111]

If you hit f5 then it refreshes fine, so it isn't the query. I am running out of ideas!

[aytee111]

I have looked on google but found nothing that jumps out, except if you are running any other code at the same time? Maybe post a small sample of your database.

[LtdLUk]

me too that's why I reached out to this forum.

[aytee111]

If you can't post your db, then start a new thread for timer not working. Either that or go back to manual, where the user hits Refresh.