469,269 Members | 1,006 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,269 developers. It's quick & easy.

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

Jun 22 '06 #1
4 1548
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.

<le*********@natpro.com> wrote in message
news:11**********************@y41g2000cwy.googlegr oups.com...
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

Jun 22 '06 #2
Bri
le*********@natpro.com wrote:
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


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

Jun 22 '06 #3
On 22 Jun 2006 04:23:30 -0700, le*********@natpro.com wrote:
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


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
--

Jun 23 '06 #4
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:
On 22 Jun 2006 04:23:30 -0700, le*********@natpro.com wrote:
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


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
--


Jun 23 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Nyuszi | last post: by
3 posts views Thread by Christoph Boget | last post: by
reply views Thread by adolph | last post: by
2 posts views Thread by lindseyhansen | last post: by
13 posts views Thread by Keith Wilby | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.