Refresh a form

  • Thread starter Thread starter Phil W
  • Start date Start date
P

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
 
Phil W said:
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.
Click to expand...

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
 
Back
Top