Making subform field visible/invisible

[Snufflz]

Hi,



I have a form for the input of staff member's salary increases. On the main form I have a list box for a member of staff to be selected. As the salary details are stored in a separate table to the name details, the main form has two subforms, one for data input and one to list the salary history for the member of staff selected.

When the main form is opened, before a name is selected from the list box, the salary of the first member of staff is displayed on the subforms.

As soon as a staff member is selected, the subforms update and show the correct data.

My question is this:

Is it possible for the subforms to be blank until a name is selected from the list box or:

Is it possible for the Salary_before_update field be invisible on the subform until a name is selected from the main form list box.

I have experimented with setProperty/visible on the subform but that returns an error when the main form is loaded.

I would very much appreciate any help with this.

Thank you.

[maximus]

I have a subform Table4 in my main form and I want the visible property of a control on the subform C to change with the value selected in a combobox Col1 in the main form. When you select Yes in Col1 the control (TextBox) C is visible and invisible when u select No in the subform.

Code as below.

If Me.Col1 = "Yes" Then
Form.Table4!C.Visible = True
Else
Form.Table4!C.Visible = False
End If

[Snufflz]

That is most kind of you. Since I posted the thread I have worked it out myself but I am very grateful for your help.

Regards.

I have a subform Table4 in my main form and I want the visible property of a control on the subform C to change with the value selected in a combobox Col1 in the main form. When you select Yes in Col1 the control (TextBox) C is visible and invisible when u select No in the subform.

Code as below.

If Me.Col1 = "Yes" Then
Form.Table4!C.Visible = True
Else
Form.Table4!C.Visible = False
End If

[RuralGuy]

That is most kind of you. Since I posted the thread I have worked it out myself but I am very grateful for your help.

Regards.

Maybe you would like to use the Thread tools and mark this thread as Solved then.