Command Button to be enabled only when both listbox items are selected

[dbruzzese84]

Does anyone know how to start a form with a search button disabled, but when you choose a selection in listbox1 and listbox2 the button becomes enabled?

[Rabbit]

Does anyone know how to start a form with a search button disabled, but when you choose a selection in listbox1 and listbox2 the button becomes enabled?

In the after update of each listbox have it check for nulls, if both are not null then enable.

[dbruzzese84]

In the after update of each listbox have it check for nulls, if both are not null then enable.

what is the command for "not null' when referring to a listbox

[HenHouse]

You can use NOT "" if a null value implies the same as a zero-length string. "" indicates a ZLS in a text field.

[dbruzzese84]

You can use NOT "" if a null value implies the same as a zero-length string. "" indicates a ZLS in a text field.

I am sort of new to access so plz explain in beginner terms lol

[Rabbit]

A zero length string is not the same thing as a null.

IsNull(String) returns true if the string is null. Not IsNull(String) returns true if the string is not null.

[dbruzzese84]

A zero length string is not the same thing as a null.

IsNull(String) returns true if the string is null. Not IsNull(String) returns true if the string is not null.

so the code would be:

If list1 and list2 Not IsNull(string) then
commandbutton.enabled=true ?

[Rabbit]

so the code would be:

If list1 and list2 Not IsNull(string) then
commandbutton.enabled=true ?

No, it would be

If Not IsNull(Me.list1) And Not IsNull(Me.list2) Then