display an option group jnewl 12/29/2008 4:48:01 PM 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

Re: display an option group "Damon Heron" <damon_327[ at ]hotmail.com> 12/29/2008 5:22:11 PM 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 "jnewl" <jnewl[ at ]discussions.microsoft.com> wrote in message news:CBB1A788-C5EE-4949-904E-71D60E1FDF3F[ at ]microsoft.com... [Quoted Text] > 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

Re: display an option group fredg <fgutkind[ at ]example.invalid> 12/29/2008 6:33:30 PM On Mon, 29 Dec 2008 08:48:01 -0800, jnewl wrote: [Quoted Text] > 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. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail

Re: display an option group jnewl 12/29/2008 8:26:01 PM thanks for your help "Damon Heron" wrote: [Quoted Text] > 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 > > > "jnewl" <jnewl[ at ]discussions.microsoft.com> wrote in message > news:CBB1A788-C5EE-4949-904E-71D60E1FDF3F[ at ]microsoft.com... > > 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 > > >

Re: display an option group jnewl 12/29/2008 8:26:01 PM thanks for your help "fredg" wrote: [Quoted Text] > On Mon, 29 Dec 2008 08:48:01 -0800, jnewl wrote: > > > 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. > -- > Fred > Please respond only to this newsgroup. > I do not reply to personal e-mail >