Using search form with listbox to goto record

[dweekley]

I have created a search form with a listbox based on a query. The search form is working as planned. Having trouble locating how to pass the record ID in the listbox from the search form to my main form. The listbox has the record ID in it, but the column width is at '0' so it doesn't display. I am thinking the docmd.gotorecord is wrong. Also my main form was looking at the table, but I figured a query was probably the better way to go.

TIA

[aytee111]

You need an event to happen in order to pass the ID to the main form. What is the sequence of events, is the main form already open or are you opening it after the search? If you are opening the form, use the "WHERE" part of the openform command to set the criteria ("ID=" & listbox value). If the form is already open, then set its filter:
Forms("YourFom").Filter = "ID=" & listbox value
Forms("YourForm").FilterOn = True

[dweekley]

Ah...one of these days I'll get the [] and ! figured out. Thank you much.

Should I be concerned with clearing the filter? The main form opens to a new record so I am thinking no?