Access2000: unmeant automatic refresh in subform

[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

 

[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

This oesn't look like a refresh, this is a requery
are you sure you don't use a timer?

 

[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?

 

[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?

I hava no glue what's that is, but look in the properties if there is
a timer or a requery function

 

[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