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.
Code:
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