Tickbox and Textbox

[dmkennard2]

Hi,
I have a tickbox, when the tickbox is true i have a textbox appear.
If i scroll through the records the textbox stays visible whether or not the tickbox is true or false on the other records.
Is there a way i can have the form refresh so the textbox stays hidden when scrolling through.

The textbox initially has the visible property set to false and the following statement is behind the tickbox.

If Services.Value = True Then
Notes.Visible = True
Else
Notes.Visible = False
End If

Thanks in advance.

Dazz

 

[snyperx3]

Is Services bound to a field of the recordset? If so you can reference that field in the Form_Current Event.

-Pete

 

[dmkennard2]

Excellent. I think that was one of the only ones i did not try as its not abvious.

Thanks again.

Dazz

 

[snyperx3]

Yeah, I learned about it here myself. =]

http://www.tek-tips.com/viewthread.cfm?qid=1131419&page=1

-Pete