What about "undo" in the linked comboboxes`?

D

Douglas J. Steele

If you've selected a different value in Combo A, then Combo B should refresh
to reflect what's in Combo A. There's no reason to use the Esc key.

Or have I misinterpretted your question?
 
B

Bertrand

Maybe my question was unclear. The [Esc] key is used to cancel edits on
databound forms. If the user chooses to cancel edits then Combo B does not
return to the original value if combo A has been changed. Is there a
workaround for this?

Rgds
Bertrand

Douglas J. Steele said:
If you've selected a different value in Combo A, then Combo B should refresh
to reflect what's in Combo A. There's no reason to use the Esc key.

Or have I misinterpretted your question?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Bertrand said:
Having worked with the classic "parent-child linked comboboxes problem" I
reached the same solution as in this article:
http://office.microsoft.com/en-gb/access/HA011730581033.aspx

But what about undo? If I select a different value in the boxes and then
press [Esc] the child combo dos'ent refresh. Any solutions to this
problem?

rgds
Bertrand
Click to expand...
Click to expand...
 
D

Douglas J. Steele

Sorry, I don't know.

Does it make a difference if you hit the Esc key more than once? If you can
do it in code, Me!ComboB.Undo might work

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Bertrand said:
Maybe my question was unclear. The [Esc] key is used to cancel edits on
databound forms. If the user chooses to cancel edits then Combo B does not
return to the original value if combo A has been changed. Is there a
workaround for this?

Rgds
Bertrand

Douglas J. Steele said:
If you've selected a different value in Combo A, then Combo B should
refresh
to reflect what's in Combo A. There's no reason to use the Esc key.

Or have I misinterpretted your question?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Bertrand said:
Having worked with the classic "parent-child linked comboboxes problem"
I
reached the same solution as in this article:
http://office.microsoft.com/en-gb/access/HA011730581033.aspx

But what about undo? If I select a different value in the boxes and
then
press [Esc] the child combo dos'ent refresh. Any solutions to this
problem?

rgds
Bertrand
Click to expand...
Click to expand...
Click to expand...
 
Top