display an option group

  • Thread starter Thread starter jnewl
  • Start date Start date
J

jnewl

developing an application for our call center.
i want an option group to display only when a field in the table is greater
than zero.

how do i code that? can build option groups with no problem, but can not
determine how to display based on other conditions.

thanks for your help
 
This is a form bound to the table, correct?
First, set the option group visible property to no.
in the form's current event :

Private Sub Form_Current()
If Me.Textbox >0 Then 'Textbox bound to field
Me.optgrp1.Visible = True
Else
Me.optgrp1.Visible = False
End If
End Sub

Substituting your textbox name and option group name, of course.

Damon
 
developing an application for our call center.
i want an option group to display only when a field in the table is greater
than zero.

how do i code that? can build option groups with no problem, but can not
determine how to display based on other conditions.

thanks for your help
Click to expand...

Code the Form's Current event:
Me.[OptionGroupName].Visible = Me.[TextControlName] >0

Place the same code in the [TextControlName] AfterUpdate event.
 
thanks for your help

fredg said:
developing an application for our call center.
i want an option group to display only when a field in the table is greater
than zero.

how do i code that? can build option groups with no problem, but can not
determine how to display based on other conditions.

thanks for your help
Click to expand...

Code the Form's Current event:
Me.[OptionGroupName].Visible = Me.[TextControlName] >0

Place the same code in the [TextControlName] AfterUpdate event.
Click to expand...
 
thanks for your help

Damon Heron said:
This is a form bound to the table, correct?
First, set the option group visible property to no.
in the form's current event :

Private Sub Form_Current()
If Me.Textbox >0 Then 'Textbox bound to field
Me.optgrp1.Visible = True
Else
Me.optgrp1.Visible = False
End If
End Sub

Substituting your textbox name and option group name, of course.

Damon
Click to expand...
 
Back
Top