Making a hide/appear base on a value

  • Thread starter Thread starter FrunkaBlunka
  • Start date Start date
F

FrunkaBlunka

Hi,

I have seen numerous topics on this subject but none have helped me.

I have a textbox called txtPaymentDisplay. When txtPaymentDisplay value
is equal to 0 I need a llblPaymentComlete to appear. Now these two are
in a subform. I have a button that refreshs the form data but it is on
my main form which also has that subform on it.

If Me!txtPaymentDisplay.Value = 0 Then
Me!txtPaymentComplete.Visible = True
End If
End Sub

Is my code right?
Which event do I place the code?


Thanks

Blunka
 
Hi, Blunka.

Yes, your code is right. Place it in the AfterUpdate event of the
txtPaymentDisplay, or, if that control is not manually editid, then in the
AfterUpdate event of the subform, so that it will run each time you refresh
the subform with your command button.

Hope that helps.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I hide a label based on the value of a textbox 2
Update subform with combobox change on main form 1
filtering a form based on the values of a subform 0
Need help on how to pass calculated field from a form to another form 0
Validation Rules for a Control on a Form (?) 4
Requery subform Field based on different Field's value 0
Hide Columns in a datasheet Subform based on a another field value 1
Hiding a control based on the value of a cbo box column 2

Back
Top