Bind and unbind Combo Box with VBA

[DBnub11]

Hi

I need to bind and unbind combo boxes in a form any ideas how to do that?

 

[JANR]

To unbind set the controlsource to ZLS

Me.NameOfCombo.ControlSource = vbNullString

To Bind:

Me.NameOfCombo.ControlSource = "Customer"

JR

 

[DBnub11]

Thanks a bunch I finally got my form working right now. The problem was I unbound everything to prevent acidental editing so when I filters the non filtered data was not hooked up to anything