Access2000: unmeant automatic refresh in subform

A

Artur Loewen

Hi NG!

I got the following Problem in one of my Forms in Access 2000:
There are detail records (depending on the main record in the main form)
that are shown in endless view.
The list of the records in the subform get refreshed automatically every 2
minutes and I haven't got a clue why this happens.
This is really bad, when inserting text for example in the third row in the
second field, and the list refreshes it selfs, the cursor is placed in the
first field in the first row.
The programm is used by multiple people in a network.

Has anyone any idea why the subform refreshes it selfs, and how to prevent
that.
I'm grateful for every hint.

Greets
Artur
 
A

Andi Mayer

Hi NG!

I got the following Problem in one of my Forms in Access 2000:
There are detail records (depending on the main record in the main form)
that are shown in endless view.
The list of the records in the subform get refreshed automatically every 2
minutes and I haven't got a clue why this happens.
This is really bad, when inserting text for example in the third row in the
second field, and the list refreshes it selfs, the cursor is placed in the
first field in the first row.
The programm is used by multiple people in a network.

Has anyone any idea why the subform refreshes it selfs, and how to prevent
that.
I'm grateful for every hint.

Greets
Artur
Click to expand...
This oesn't look like a refresh, this is a requery
are you sure you don't use a timer?
 
A

Artur Loewen

You're right it's a requery, not just a refresh.
I'm absolutly sure, there is no timer, but I forgot to mention I'm using a
MSComCtl2.MonthView and I could point it down to this one.
The records in the subform are filtered by the selected date in the
MonthView and I process the message MonthView_SelChange. But the question
is: Why do I get a MonthView_SelChange every 2 min, without doing anything?
 
A

Andi Mayer

You're right it's a requery, not just a refresh.
I'm absolutly sure, there is no timer, but I forgot to mention I'm using a
MSComCtl2.MonthView and I could point it down to this one.
The records in the subform are filtered by the selected date in the
MonthView and I process the message MonthView_SelChange. But the question
is: Why do I get a MonthView_SelChange every 2 min, without doing anything?
Click to expand...
I hava no glue what's that is, but look in the properties if there is
a timer or a requery function
 
A

Artur Loewen

Hmm, there is nothing that looks like a timer or requery or anything like
that.
I solved the problem now by checking wether the date has really changed or
not and depending to that execute my function.
So long, thx for trying to help me.

Greets

Artur
 
Top