Form Refresh

  • Thread starter Thread starter Dave Elliott
  • Start date Start date
D

Dave Elliott

How can i make the form refresh itself so that the label either shows after
the update or is invisible?
I tried me.repaint and me.refresh but this did not work.
I dont want to requery or else it will leave the current record.


If ([Flag]) = True Then
Label433.visible = true
else:
label433.visible = false
end if
 
After the update of what ?
the code needs to go in the after update event of a field
If Flag = True Then
Label433.visible = true
Else
Label433.visible = false
end if
 
after the update of the control Flag, it then makes the label433 visible,
Flag is a yes/no check box

Dennis said:
After the update of what ?
the code needs to go in the after update event of a field
If Flag = True Then
Label433.visible = true
Else
Label433.visible = false
end if


Dave Elliott said:
How can i make the form refresh itself so that the label either shows
after
the update or is invisible?
I tried me.repaint and me.refresh but this did not work.
I dont want to requery or else it will leave the current record.


If ([Flag]) = True Then
Label433.visible = true
else:
label433.visible = false
end if
 
Back
Top