run a silent 'SELECT QUERY' in the background

[Fred75]

Facing a small little problem -

I have searched the forum but to no avail...

I have designed a macro which runs a two separate OpenQueries, Save and Close statement based on a timer in an attempt to mimick the running of a silent 'SELECT QUERY' in my Access 2003 database project.

Is there a cleaner way to silently run this 'SELECT QUERY' in the Background and thus without the using the Open and Close query commands, to prevent the as my screen slicing effect as a result of this.

Thanks.

 

[Laoujin]

I'm not entirely sure what you mean...

You can use the following to automatically Requery a form:

' This line can be in the Form_Load event
Me.TimerInterval = 100000

' This code in the Form_Timer event
Me.RecordSource = Me.RecordSource

This is assuming that you want to run a query that is the recordsource of a form.
If it is not, post some additional information..

 

[Fred75]

Thanks for the reply Laoujin,
I will give it a run in the morning!

But in the meatime, I was wondering if this method will requery all recordsets on my form since:
(1). It is composed of a 3 page Tab Control,
(2). Each page has its own List box lookup based on a unique 'select' query
(3). Each query perform its action on a SQL table

As mentionned in my previous post, I am running all three queries through a Macro (Action OpenQuery, Action Close) on a timer_event in order to automatically requery the linked SQL tables and update each one of the three List Boxes on my form... I believe I have attempted a form.refresh approach to no success...

But you may say Requery ain't Refresh; Point taken.

 

[Fred75]

Thanks for the advice Pat.