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!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Auto dropdown on combo box 1

Status
Not open for further replies.
daroadrunner

daroadrunner

IS-IT--Management
Joined
Jul 19, 2000
Messages
1
Location
US
In Access 97 is there any reason why a combo box will not automatically dropdown when the combo box is put in a sub form. <br><br>The auto dropdown works automatically if you start the form outside of the parent form, but refuses to do so inside the subform. I am using Got Focus event to run <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Me!cbomybox.Dropdown<br>Any reason why this wil not work?
 
Sort by date Sort by votes
You need to refer to the subform as a control.<br><br>Me![ChildFormName].Form![cbomybox].Dropdown<br><br>Change &quot;ChildFormName&quot; to the actual name of the Sub Form.<br><br>HTH<br>RDH <p>Ricky Hicks<br><a href=mailto: rdhicks@mindspring.com> rdhicks@mindspring.com</a><br><a href= > </a><br>
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

monkeysee
  • Locked
  • Question Question
Combo Box - Limit results
Replies
1
Views
696
dhookom
dhookom
visitnag
  • Locked
  • Question Question
combo box entries problem
Replies
8
Views
771
visitnag
visitnag
JanaLNelson
  • Locked
  • Question Question
Filter as you type combo box in Access
2 3
Replies
54
Views
4K
JanaLNelson
JanaLNelson
dhookom
  • Locked
  • Question Question
Make second combo box display records dependant on selection from first combo box
Replies
2
Views
504
dhookom
dhookom
JayRo71
  • Locked
  • Question Question
Select records on subform using a combo box with a twist
2 3
Replies
56
Views
3K
JayRo71
JayRo71

Part and Inventory Search

Sponsor

Back
Top