list box

[dixxy]

Hi,

Is there a way to know if a user has selected something from a list box or not?

If my user does not select a item in a list box i want to tell him about it and not open a form until something is selected.

Can this be done?

Thanks,

Sylvain

 

[TheAceMan1]

How are ya dixxy . . .

Perhaps this:

[blue]   If IsNull([purple][b][i]Me.ListboxName[/i][/b][/purple]) Then
      MsgBox "Make a selection in Listbox please!"
   Else
      DoCmd.OpenForm . . .
   End If[/blue]

See Ya! . . . . . .

 

[dixxy]

that did the trick.

Thanks again AceMan!!!

Thanks,

Sylvain