Hiding fields in a subform

[degras]

Hi,
I have a form with a category field on it. The value for the category is selected from a list. Depending upon which value is selected for the category I want to hide or make visible various fields on a subform. So for example: only if the category is "Service" do I want the "Qty" field to be visible on the subform. How is this possible?
Thanks

[pbaldy]

Generally:

http://www.baldyweb.com/ConditionalVisibility.htm

The syntax to refer to a subform if needed:

Forms Refer to Form and Subform properties and controls

[degras]

Hi, thanks for the links. I wrote some VBA code but it is not working. I put the following code in the "On Change" event:

Private Sub Category_Change()
Me!ItemsSubform.Form!Totals.SetFocus
Me!ItemsSubform.Form!ItemDate.Visible = False

If Me.Category = "Service" Then
Me!ItemsSubform.Form!ItemDate.Visible = True
End If
End Sub

The problem is, when I change the category on the main form to something other than "Service", the ItemDate on the subform still remains visible.

[pbaldy]

Not sure, as I just tested and this worked as expected:

Private Sub Combo30_AfterUpdate()
  If Me.Combo30 = "Paul" Then
    Me.SubformControlName.Form.TextboxName.Visible = False
  Else
    Me.SubformControlName.Form.TextboxName.Visible = True
  End If
End Sub

You generally have to set focus first to the subform itself before setting focus to a control on the subform. I'd also use the after update event rather than the change event. The change event fires with each keystroke; the after update won't fire until the user is done.

[degras]

I added the location of my database as a trusted location and put the code in the AfterUpdate event, but the code still gets ignored. All the controls remain visible, despite setting their visible property to false. I don't get any error message. Is there any other reason why the code is not executing? Do I need to refresh the subform or something like that? I know the code is being read by VBA because if I try to mispell one of the control names I get an error message when the code runs.

[pbaldy]

Can you post the db, or a representative sample?

[degras]

Apparently the Visible property has no effect on controls on a datasheet, so I used the ColumnHidden property instead.

[pbaldy]

Glad you sorted it out.