Hide combo box unless a field value is...

[dniezby]

I have a phone type field on a form. If my user selects MOBILE I want the form to SHOW an additional field called phone carrier.



How can I do this?

The table will store the carrier record ID BTW.

[ranman256]

use the AFTERUPDATE event when the user updates the combo box for type of phone...

sub cboPhoneType_Afterupdate()
   cboCarrier.visible = cboPhoneType = "MOBILE"
end sub

[dniezby]

Thanks this worked!

How do I get it to show the field label too? I added another line to the code but it gives me an error.

[dniezby]

Never mind. I must have had an error in my code. I got it to work.

Private Sub cboPrimaryPhone_AfterUpdate()
cboPrimaryCarrier.visible = cboPrimaryPhone = "1"
Label35.Visible = cboPrimaryPhone = "1"

End sub

The 1 is the Record ID number to the record that has Mobile from the phone type table.