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

When opening form combo box lists value

Status
Not open for further replies.
infact

infact

Technical User
Jan 9, 2006
27
US
I have a combo box with a list of two values to select from. When I open the form the previous value that was selected is displayed in that field. How do you make this field be blank when opening the form ?
Thanks.
 
Sort by date Sort by votes
Try this on Open or Load event of the form.
Code: 
 Me.ComboBoxName=""

________________________________________________________
Zameer Abdulla
Help to find Missing people
Even a thief takes ten years to learn his trade.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ameedoo3000
  • Locked
  • Question
format partition by vba code
Replies
6
Views
749
mattKnight
mattKnight
v5652
  • Locked
  • Question
Ribbon icons missing each time when MS Windows 10 update
Replies
0
Views
266
v5652
v5652
Jaime_78
  • Locked
  • Question
DoCmd.OpenReport Hangs when user wants to select location of report to save to
Replies
2
Views
278
Jaime_78
Jaime_78
Moss100
  • Locked
  • Question
Using data macro to alert user when record is added to a table.
Replies
2
Views
230
Andrzejek
Andrzejek
PrimoSteve
  • Locked
  • Question
You must use the dbSeeChanges opion with OpenRecordset when accessing a SQL Server table
Replies
9
Views
403
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top