Search results

I figured it out. The linked tables were pointing to a different location, but I couldn't see it in the Link Manager because I couldn't scroll far enough to the right to see the full path.

I have created an Access 2000 Db, and have gone through the motions of splitting the Db via the Splitting Tool. Since I have done this split, I have added forms, queries, and reports to the Front End. I have left the Back end table structures alone. This is where my problem comes into play...

How would this work if I were to build the Query in the form (using Access 2000)? I have some routines that build the query off of the data from multiple multi-select listboxes, concatenates them into a single query statement. How would I pass this query to be used as the Reports RecordSource...

It doesn't give any errors. When I click on a selection, it a) selects the value without de-selecting the "All" value, or b) selects the "All" value without de-selecting all the other values.

I posted this in the code exactly as is, and it did not work. I do appreciate your response and effort though. Is there anything I'm not doing or doing wrong?

I made sure I did a search for this topic before I posted, so please don't flame me. I'm trying to do something that in theory does not seem hard to do, but for some reason I can't translate it into code. With using a ListBox, I understand how to do a simple "when a value is selected, the...