.enable detail on a subform?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an option group in the header of a subform. When the correct choice
is made in the option group, I would like to enable the detail of subform.
Is this possible? How do I do it?
 
In the After Update event of the option group put some logic to enable or
disable the subform detail.
 
I put this in the after update event.

If Me.Findings.Value = 1 Then
Me.FF_FindingTitle.Visible = True
End If

Findings is the name of the option group
FF_FindingTitle is the name of the text box.

When I click on the option group, the text box is not visible, yet the code
is not throwing an error. I'm very new to VB and am wondering if the syntax
is correct of if there is something else I need to do.
 
Try Me.Detail.FF_FindingTitle True


goplayoutside said:
I put this in the after update event.

If Me.Findings.Value = 1 Then
Me.FF_FindingTitle.Visible = True
End If

Findings is the name of the option group
FF_FindingTitle is the name of the text box.

When I click on the option group, the text box is not visible, yet the code
is not throwing an error. I'm very new to VB and am wondering if the syntax
is correct of if there is something else I need to do.
Click to expand...
 
If I try Try Me.Detail.FF_FindingTitle True I get an exception.

The FF_FindingTitle is in the detail section of the form.
The Option box is in the header of the form.

If I use the same code, but change the name to a field in the header section
of the form, it works.
 
Sorry, go. I seldom use Headers in forms, so my syntax here might be
incorrect, but the concept is good. I was expecting the FF_FindingTitle is
in the Detail. Look at the properties of the Detail section of your form and
see what the Name propertiy is. It is probably "Detail". You may have to
get the syntax right. I'm sorry, but I don't have time at the moment to
explore it further. If I get time over the weekend, I will post back Monday.

Good Luck!
 
Never mind. I'm a big dummy. I had the detail section too small for the
data to appear. DOH! I hate it when that happens.
 
Back
Top