Ok. I'm filtering one table with another. For instance, I have a table of Venues/Clubs. I have another table that has Shows in it. When the Venue in the Shows table matches a club from the Venues/Clubs table, it filters thru all the information and work perfect.
Unfortunately, if it doesnt, then it shows up with an error that says the recordset has been deleted. Is there a way i can set up the database, to where if it doenst match, it sends back some default values?

my database is access2000

the page is at gtp-inc.com/shows.asp . Roll over something and the details window and that's where the code is. The only thing it's grabbing right now is the directions, but i want to show more venue info, if it doesnt mess it up when it doenst find the recordset.

<pre id=code><font face=courier size=2 id=code>
&lt;%
Dim MMVenue
MMVenue = (Recordset1.Fields.Item("EventLocation".Value)
%&gt;
&lt;%
Dim Recordset2__MMColParam
Recordset2__MMColParam = "No Venue"
if (MMVenue &lt;&gt; "" then Recordset2__MMColParam = MMVenue
%&gt;
</font id=code></pre id=code>


if this is really easy, oops
thanks
-fuzz


-I am beyond the line of Morality and therefore, beyond caring.