Hi all,
I have a number of fields on a form which are divided into three groups. I'm trying to get the OnLoad vba for the form to make certain groups invisible depending on criteria for the individual client loaded.
The groups are controlled by 3 invisible text boxes which draw their Yes/No data from the main table. For example if client A has a yes for 1 but a no for 2 and 3, I want only the fields associated with 1 to be visible.
I currently have a number of If/ElseIf statements in the OnLoad property of the form, but they don't seem to be working. Any help would be greatly appreciated.
I have a number of fields on a form which are divided into three groups. I'm trying to get the OnLoad vba for the form to make certain groups invisible depending on criteria for the individual client loaded.
The groups are controlled by 3 invisible text boxes which draw their Yes/No data from the main table. For example if client A has a yes for 1 but a no for 2 and 3, I want only the fields associated with 1 to be visible.
I currently have a number of If/ElseIf statements in the OnLoad property of the form, but they don't seem to be working. Any help would be greatly appreciated.
Last edited: