requery

[ytakbob]

When I do a requery of an object (date field) on a nonmodal nonpopup form....the field "disappears" when the requery (timed event) is executed.

The field reappears if I click somewhere on the form or if I minimize and then maximize....is there a semi-efficient way of refreshing the date/time field without closing and opening the form.


Access 97 Bob Schmid
bob_schmid@hmis.org
330-746-1010 ext. 1347

 

[jebry]

Hi Bob!

After you do the requery put in a Me.Repaint. That should update the information on the screen.

hth
Jeff Bridgham
bridgham@purdue.edu

 

[ytakbob]

Thanks for your response Jeff.
I tried the requery Me!txttime.Requery
and then Me.Repaint...still the same result.
the field only reappears upon running my mouse over something active on the desktop

running win 2000 Bob Schmid
bob_schmid@hmis.org
330-746-1010 ext. 1347