List Box Help

[maximus4444]

I am having problems figuring out how to run a macro if and only if a selection is made in a separate list box. Any help would be great.
Jon

 

[jfgambit]

Have you tried an IF statement on the OnClick event of the Listbox

If Me.ListBoxName = "YourChoice" Then
DoCmd.RunMacro "MacroName"
Else
End If

If the Listbox is a value then try this
If Me.listboxname.value = 1 Then
DoCmd.RunMacro "MacroName"
Else
End If

HTH