Refresh a form

[Phil W]

Hi all, I have a form that when I click on a certain check box other fields
become visable which I then fill out. Problem is, when I click check box I
have to go out of that particular record and then back in to see the desired
field appear. I have tried Me.Refresh in the AfterUpdate for the check box
but with no joy. I have also tried [Forms]![Contacts].Requery works but takes
me immediately to the first record. How do I Refresh this or at least Requery
but stay with the same record.....

Thx

 

[Keith Wilby]

Hi all, I have a form that when I click on a certain check box other
fields
become visable which I then fill out. Problem is, when I click check box I
have to go out of that particular record and then back in to see the
desired
field appear.

That sounds very odd. Post your code please.

Technical point: fields are table attributes, what you have on your form
are controls (text box, combo box, check box ... etc).

Keith.
www.keithwilby.co.uk