Make Listbox Emplty

[Eranka]

Hi



How to make a listbox appear empty or blank on form load until a value is entered into the textbox?

[June7]

Maybe you should use a combobox instead.

[Eranka]

Hey

i am trying to create a search form in access, when created the list box shows the values instead of an empty listbox, is there anyway i could empty the listbox upon form load?

[June7]

Okay, don't set listbox RowSource until input into textbox.

[Eranka]

could you please explain,

[June7]

Don't set listbox RowSource property in design view. Do it with code so in text AfterUpdate event, something like:

Sub textboxname_AfterUpdate()
Me.listboxname.RowSource = "SELECT * FROM sometable WHERE somefield='" & Me.textboxname & "'"
End Sub

[Eranka]

It worked, Thanks alot mate.