Search from a list box

[UT227]

This might be hard to explain. I have a form [frmEventsEnter]. I search with month and year fields. The results appear in the list box [lstEventsListing]. I want to be able to click on the list box and the information appear in the form.


The row source for the list box is: SELECT [EventID], [EventDate], [Event] FROM qryEventListing ORDER BY [EventDate];
I tried to put on click: Me.EventID = lstEventListing
That took me to the debugger.

[Robyn_P]

I think you just need Me.EventID = me.lstEventListing.selected (assuming it's not a multi-select list box). I do this loads on my forms. Think that's all you need but will check and get back to you.

[UT227]

No. Went to the debugger again.

[Robyn_P]

Is it a bound or unbound form? I assume the latter, in which case it should be the recordsource of the form that you're adjusting I think. [Forms]![Events].RecordSource = "SELECT * FROM Bla WHERE [EventID]= " & Me.lstEventListing.selected. Hopefully that should work if I've understood correctly

[UT227]

It's a bound form. I need it to open up to the record I select from the list box.