access97, is there an event triggered when you undo the contents of a field

I've got a comboBox with 2 choices and based on the choice, I make
button A or button B visible

if choose choice 1, button A is visible
now, I undo the choice so that the comboBox is null, but button A is
still visible

I tried the field's onChange event, but no luck

I could use the form's timer event, but I wonder if there's a better
event to use

re: access97, is there an event triggered when you undo the contents of a field

The Undo events were introduced in Access 2000, so are not available in 97.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<lesperancer@natpro.com> wrote in message
news:1150975410.526121.232080@y41g2000cwy.googlegr oups.com...[color=blue]
> I've got a comboBox with 2 choices and based on the choice, I make
> button A or button B visible
>
> if choose choice 1, button A is visible
> now, I undo the choice so that the comboBox is null, but button A is
> still visible
>
> I tried the field's onChange event, but no luck
>
> I could use the form's timer event, but I wonder if there's a better
> event to use[/color]

re: access97, is there an event triggered when you undo the contents of a field

lesperancer@natpro.com wrote:[color=blue]
> I've got a comboBox with 2 choices and based on the choice, I make
> button A or button B visible
>
> if choose choice 1, button A is visible
> now, I undo the choice so that the comboBox is null, but button A is
> still visible
>
> I tried the field's onChange event, but no luck
>
> I could use the form's timer event, but I wonder if there's a better
> event to use[/color]

What about the AfterUpdate event? Or better yet, since you are looking
at only two choices, use an Option Box instead of a Combo, that way the
can only choose one or the other, Null isn't possible.

--
Bri

re: access97, is there an event triggered when you undo the contents of a field

On 22 Jun 2006 04:23:30 -0700, lesperancer@natpro.com wrote:
[color=blue]
>I've got a comboBox with 2 choices and based on the choice, I make
>button A or button B visible
>
>if choose choice 1, button A is visible
>now, I undo the choice so that the comboBox is null, but button A is
>still visible
>
>I tried the field's onChange event, but no luck
>
>I could use the form's timer event, but I wonder if there's a better
>event to use[/color]

What do you mean by "undo"? Do you highlight and delete? Do you push <esc>?
When you "undo", do you want both buttons to be invisible?

When the form is first opened is either button A or button B visible?
If you don't want either button to be visible, make a third choice in the
ComboBox which is "niether" which makes both buttons invisible. Make that
choice the default value.

Just a wizard prodder
Chuck
--

re: access97, is there an event triggered when you undo the contents of a field

using the 'esc' key to undo the contents of the combo

say I've got a blank form, and I start adding a new record

I fill in some data, including selecting choice 1 from the combo box,
which makes button A visible

now say, I don't want to finish the entry session, and can't save it
because required fields are missing data

I hit esc-ape twice, and the form is cleared of my keyed data, and I'm
no longer in new-record mode

the combobox is blank, but button A is still visible

the idea of third combo box selection is a good thought, so is the idea
of an 'undo' button
but there are too many other generic ways to undo (escape, ctl-z, edit
pull down menu)

if the combo box is null, I don't want to see either button


Chuck wrote:[color=blue]
> On 22 Jun 2006 04:23:30 -0700, lesperancer@natpro.com wrote:
>[color=green]
> >I've got a comboBox with 2 choices and based on the choice, I make
> >button A or button B visible
> >
> >if choose choice 1, button A is visible
> >now, I undo the choice so that the comboBox is null, but button A is
> >still visible
> >
> >I tried the field's onChange event, but no luck
> >
> >I could use the form's timer event, but I wonder if there's a better
> >event to use[/color]
>
> What do you mean by "undo"? Do you highlight and delete? Do you push <esc>?
> When you "undo", do you want both buttons to be invisible?
>
> When the form is first opened is either button A or button B visible?
> If you don't want either button to be visible, make a third choice in the
> ComboBox which is "niether" which makes both buttons invisible. Make that
> choice the default value.
>
> Just a wizard prodder
> Chuck
> --[/color]