Problem with non-stopping listbox refresh

[perlfan]

Hello!

I have a problem with listboxes which I refresh via Form_Current().
Access continuesly refreshes the listbox, so it is impossible to work with it.
Of course, I only want the query to be executed only once and then nothing else should happen. THIS problem only occurs in case I have a function like nettotalj(...) integrated in the query. Without a function the query works nicely (executed only once). Isn't that a strange behaviour? Can somebody help me here? Thanks in advance!!! Frank

SELECT Jobs.JobID, Jobs.status AS Status, Customers.Company_Name AS [Customer Name], Jobs.DeliveryDeadline AS [Delivery Deadline], nettotalj([jobs]![JobID],[jobs]![tax]) AS [Net Sum], grosstotalj([jobs]![JobID],[jobs]![tax]) AS [Gross Sum], taxtotalj([jobs]![JobID],[jobs]![tax]) AS [Tax Total]
FROM Customers INNER JOIN Jobs ON Customers.CustomerID = Jobs.CustomerID
WHERE (((Jobs.status)="pending"))
ORDER BY Jobs.JobID DESC;

 

[ghudson]

The Form_Current event fires every time you move to another record. You should put your code in the Form_Open event to only fire the first time the form is opened.

Check these out for more info...

Open Event [Access 2003 VBA Language Reference]

Current Event [Access 2003 VBA Language Reference]

 

[perlfan]

Thx - but the form_open also didn't work:

Private Sub Form_Open(Cancel As Integer)
Me!Liste2.Requery
End Sub

--> there is still a loop, i.e. access doesn't stop to execute the query. Also when I click on a line in the listbox, it gets refreshed again, even though I have no on_click event in the form. Strange. Anybody with advice?

I am using Access 2007 & Win 7 32bit.

Thanks - Frank