form requery and conditional Formatting glitch?

DAObermeyer

Hey all, first time here.

I have a database that is designed to be opened and viewed at other locations on the network.

I use Form (A) to modify Data in Table (A), and Form (B) is used scrictly to view.

Now It works great and updates every 10 seconds with a form.requery on a timer event.

Now This display is to give Scheduled and Actual times. As times are posted, I use Conditional formatting to change the colors reflecting on time, due soon, or late.

However, my problem is if the Computer is left alone, eventually the computer will stop (seems to be random) adjusting the colors as I requested. As soon as you hover the mouse over the form (Access Window), it will then wake back up and adjust the colors again.

However I wish to not use form.requery only because i want the window to not slide back up to the top of the list every time.


Any Suggestions?

Jan 8 '08 #1

PianoMan64

Well as for the requery, that is simply by design because it has to display the first record(s) from the top of the database.

If you are able to put a bookmark into the location where you'd like to be and then requery from that point, you're able too.

If you need assistants in how to do that in code, let me know.


Joe P.

Jan 22 '08 #2