display an option group

[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

 

[Damon Heron]

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

 

[fredg]

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

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

Place the same code in the [TextControlName] AfterUpdate event.

 

[jnewl]

thanks for your help

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

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

Place the same code in the [TextControlName] AfterUpdate event.

 

[jnewl]

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