Empty combobox values when access form loads vba

[svuyyuru]

I want to empty the combobox every time when form loads. Using the below code

Private Sub Form_Load()
combo1.RowSource = ""
End Sub

But Combobax is not emptying.

 

[EternalMyrtle]

You need the Me. in front of your control name. I usually do this:

Me.cboComboBoxName = Null

 

[EternalMyrtle]

You should also be using the On_current if you want this to work when changing records. On_Load only works the very first time the form is loaded and the box will not be emptied when switching records

 

[svuyyuru]

Not working, i mentioned like this

Private Sub Form_Current()
Me.combo1 = Null
End Sub

 

[EternalMyrtle]

Is this a bound control or unbound?

Are you sure you are referring to your control name in your code and not the field name?

Also, I had this problem once and it was because of other code. Is this all of the code?

 

[svuyyuru]

It is Unbound control.
Yes i'm referring control name.
My full code inside the onEnter event

Private Sub Combo1_Enter()
Me.Combo1.RowSourceType = "Table/Query"
Me.Combo1.RowSource = "Select F1 from Dropdownvalues " & _
"WHERE F1 <> 'FM'; "
End Sub

 

[EternalMyrtle]

I see this was a double post: http://www.access-programmers.co.uk/forums/showthread.php?t=261296

@ByteMyzer did a good job of explaining why this is happening.