I normally use the on focus event to initiate the docmd.dropdown for a combo box lookup. In this case the combo box has focus when the form is opened so would rather use the on change event to initiate the docmd.dropdown. The problem is that the after update event opens a 2nd form and the combo box remains open in that 2nd form.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
combo box docmd.dropdown using on change event 1
- Thread starter F2F4
- Start date
-
1
- #2
TheAceMan1
Programmer
How are ya F2F4 . . .
Note: [blue]DoCmd.DropDown works as a toggle![/blue] So in your [blue]AfterUpdate[/blue] event, just execute the command again!
[blue]Your Thoughts? . . .[/blue]
See Ya! . . . . . .
Be sure to see thread181-473997 [blue]Worthy Reading![/blue]![[thumbsup2]](/data/assets/smilies/thumbsup2.gif "[thumbsup2] [thumbsup2]")
Also faq181-2886 [blue]Worthy Reading![/blue]
Note: [blue]DoCmd.DropDown works as a toggle![/blue] So in your [blue]AfterUpdate[/blue] event, just execute the command again!
[blue]Your Thoughts? . . .[/blue]
Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]
- Thread starter
- #3
Thanks TheAceMan1
I didn't realize that the combo dropdown was a toggle - that solved the problem with the residual dropdown on the 2nd screen - That makes twice you've helped me. Now I understand why you and PHV are so active - probably received this timely help when you first joined and feel indebted. Another factor I am appreciating is in the process of trying to solve other user's problems you increase your problem solving speed. Reminds me of how speed chess improves one's overall chess ability.
Thanks again
F2F4
Any comments?
I didn't realize that the combo dropdown was a toggle - that solved the problem with the residual dropdown on the 2nd screen - That makes twice you've helped me. Now I understand why you and PHV are so active - probably received this timely help when you first joined and feel indebted. Another factor I am appreciating is in the process of trying to solve other user's problems you increase your problem solving speed. Reminds me of how speed chess improves one's overall chess ability.
Thanks again
F2F4
Any comments?
TheAceMan1
Programmer
F2F4 . . .
Glad you got it!
Note: Speed in problem solving is derived from [blue]knowledge and experience combined![/blue]
Do take a good look at one of the links at the bottom of my post.
You take care . . . [blue]Ya Hear![/blue]
See Ya! . . . . . .
Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]
Glad you got it!
Note: Speed in problem solving is derived from [blue]knowledge and experience combined![/blue]
Do take a good look at one of the links at the bottom of my post.
You take care . . . [blue]Ya Hear![/blue]
Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]
- Status
Similar threads
