if a not visible control on a single form = 1, Control 1 and 2 are not visible

[Oblio]

Hi.

On a Single Form type named "f_t_Address_Details" I have a control named "txt_Categories_Level_1_ID" on a single tab named "Asset Details_Page"(but may add more tabs in the future just in case that matters).

If the "txt_Categories_Level_1_ID"control = 1, I want the following two controls named "txt_MAC_Address" and "txt_IP_Address" to be visible, otherwise I want the them to be not visible.

In the On Open event I tried the following VBA.

IIf(f_Asset_Details.Controls!txt_Categories_Level_1_ID = 1, f_Asset_Details.Controls!txt_MAC_Address.visible=true,f_Asset_Details.Controls!txt_MAC_Address.visible=False)

but I just get a Compile Error: Syntax error" message.



Can anybody assist me with this ?


Thank you so much for helping me out with this...

Thanks,

Oblio

[June7]

That is not correct use of IIf() function.

Use If Then Else structure.

Or

With Me
.txt_MAC_Address.Visible = .txt_Categories_Level_1_ID = 1
.txt_IP_Address.Visible = .txt_Categories_Level_1_ID = 1
End With

Or use Conditional Formatting to set Enabled/Disabled.

[Gicu]

And you want to move the code from the Open event to the Current event of the form (and probably also reference it in the AfterUpdate event of the txt_Categories_Level_1_ID control if it is editable).

Cheers,

[Oblio]

THANKS SO MUCH !!!!
I will get it working and post... thanks very much June7

[Oblio]

Awesome !!! That is very kind of you to help... I will try your solution as well