DCOunt not being refreshed

  • Thread starter Thread starter geebee
  • Start date Start date
G

geebee

Hi,

I have some fields in my form, like the following:

="1: " & DCount("[vouchamt]","FY02_BASETABLE","[Name] =
[Traveler] and [vouchrec] =0 and [cancel] = 0 and [fy] =
[forms]![password]![fy] and DateDiff('m', [start date],
now()) <=1")

The problem is, the value in the field is slow to load or
show. However, when the user moves the mouse over the
field, the value shows up. I have no "OnMouseMove"
event, so that is not why the value is not being
immediately shown.

Does anyone know why the value is not being immediately
show, and how I can speed up the display of the value?

Thanks in advance,
geebee
 
If FY02_BASETABLE has lots of records, and the fields you reference from
that table are not indexed, there will be a pause while DLookup() scans the
whole table, to find the records required.

Are you sure that the value only displays when the user moves the mouse over
the textbox? My bet is, the value displays after a certain pause, regardless
of whether the user moves the mouse over the textbox or not.

Yes? No?

HTH,
TC
 
Hi,

Thanks. You have a point. I guess the values being
refreshed when mouseover is just a coincidence. I will
try indexing the fields referred to.

-----Original Message-----
If FY02_BASETABLE has lots of records, and the fields you reference from
that table are not indexed, there will be a pause while DLookup() scans the
whole table, to find the records required.

Are you sure that the value only displays when the user moves the mouse over
the textbox? My bet is, the value displays after a certain pause, regardless
of whether the user moves the mouse over the textbox or not.

Yes? No?

HTH,
TC


Hi,

I have some fields in my form, like the following:

="1: " & DCount("[vouchamt]","FY02_BASETABLE","[Name] =
[Traveler] and [vouchrec] =0 and [cancel] = 0 and [fy] =
[forms]![password]![fy] and DateDiff('m', [start date],
now()) <=1")

The problem is, the value in the field is slow to load or
show. However, when the user moves the mouse over the
field, the value shows up. I have no "OnMouseMove"
event, so that is not why the value is not being
immediately shown.

Does anyone know why the value is not being immediately
show, and how I can speed up the display of the value?

Thanks in advance,
geebee
Click to expand...


.
Click to expand...
 
Back
Top