"Requery" won't stop - please help!

[perlfan]

Hi!!!

Couldn't fix this one for 2 hrs now, so your help is appreciated!!

I do fill a list field with a sql query working with functions, too. The query is initiated "on click".

The query:

SELECT quotes.QuoteID, quotes.QuoteDate AS [Quote Date], nettotal([quotes]![QuoteID]) AS [Net Sum], grosstotal([quotes]![QuoteID]) AS [Gross Sum], taxtotal([quotes]![QuoteID]) AS [Tax total], quotes.tax AS [Tax Rate], quotes.CompanyID, quotes.DeliveryDeadline, quotes.CustomerID
FROM quotes INNER JOIN customers ON quotes.CustomerID = customers.CustomerID
WHERE (((quotes.CustomerID)=[Form]![CustomerID]));

This is how I initiate the query:

Me!Liste31.Requery

My problem is that once I have clicked the button, the query is executed everytime I scroll my mouse in the particular form. This causes error messages later on, so I only want to fill the list field once! Can somebody help me? Would be great!!!

Thanks, Frank

 

[Rich]

What event on the form triggers the Requery?

 

[perlfan]

What event on the form triggers the Requery?

It's a click on a button that triggers the requery:

Private Sub Befehl26_Click()
Me!Liste31.Requery
End Sub

I don't understand why the requery doesn't happen only once but is repeated everytime I scroll after I've clicked the button.