I have a form, when a value is picked in the first listbox I want the second listbox to display only the records that go with the first listbox. I know how to write a select statement to retrieve the records. My problem is where would I put this code. If I put it on load form I get an error message, because it can't find my variables.

Perhaps you could place it in the first list box's 'OnChange' event or the second list box's 'GotFocus' event. You may also want to take a look at the post titled, 'Cascading text boxes' under the General topic for more information.

~Abby