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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Clear text in one combo from procedure in another combo

Status
Not open for further replies.
BarryMurphy

BarryMurphy

Technical User
May 20, 2001
56
NZ
I have a DAO database in Access 2000 with a form containing two combo boxes. I have code in the AfterUpdate event procedure of one combo box that tests whether, if there is text in the other combo box, it is compatible with the selection just made in the current combo box. If it is not compatible, I want the text to be cleared. How can I do this? If I try to use SetFocus to go into the other combo and clear it, I get "Run-time error '2110' Microsoft Access can't move the focus to the control ComboName."
 
Sort by date Sort by votes
I have the answer now, i.e. ComboName.Value = ""
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

PrimoSteve
  • Locked
  • Question
Fill in 2nd Textbox2 from Textbox1
Replies
3
Views
402
PrimoSteve
PrimoSteve
monkeysee
  • Locked
  • Question
Combo Box - Limit results
Replies
1
Views
349
dhookom
dhookom
Kennelbloke
  • Locked
  • Solved
Subform not updating in parent form
Replies
10
Views
498
Kennelbloke
Kennelbloke
JanaLNelson
  • Locked
  • Question
Filter as you type combo box in Access 2
2 3
Replies
54
Views
1K
JanaLNelson
JanaLNelson
visitnag
  • Locked
  • Question
combo box entries problem
Replies
8
Views
285
visitnag
visitnag

Part and Inventory Search

Sponsor

Back
Top