How to refresh a field automatically?

[sujith123]

Hi All,

I have a form which has a field named VendorID it gets data from the following query

SELECT TOP 2 V.VendorID, V.VendorName, COUNT(A.ClaimNumber) AS Total_assignment, V.VendorStatus
FROM dbo.VendorMaster V LEFT OUTER JOIN
dbo.VendorAssignment A ON V.VendorID = A.VendorID
GROUP BY V.VendorID, V.VendorName, V.VendorStatus
HAVING (V.VendorStatus = N'Active')
ORDER BY COUNT(A.ClaimNumber)

So, if we look at the code it should give me top 2 by ascending , but whats happening here is once i refresh it gives me top 2 and it stays the same until and unless i go to view mode and come back to the form mode( refresh) again. Can someone please help me with the automatic code or something which can make this one update automatically?

Thanks a lot for your help.

[jforbes]

What kind of field is this? If it is a ListBox, a .Refresh wont cut it. You'll need to use a .Requery.

.Refresh only requeries the .RecordSource of the Form. A .Requery can requery the .RowSource of a Control.

This might be more clear than what I have typed (then again it might not):
http://support.microsoft.com/kb/209634