requery - save record

[deekras]

i have a datasheet. when the user double clicks [member number] field, a new form opens so that user can enter details. after the user enters details, the [details date] field in the datasheet is updated and the background color of some fields in the datasheet is changed. to show these changes i have code to requery.

my question is: where is the best place to have the requery - afterupdate in details form or when user closes the details form?

also, after it requeries it goes back to the first record. how can i have it save the record? i have played around with setfocus and findrecord, but i can't get it to work. maybe i have it in the wrong place.

any ideas?

 

[deekras]

i need the form to requery so i can get the appropriate background colors - showing that the member has been dealt with today. perhaps i could save the record, but how could i code to change the color of the background?