Hi Charles,

I suggest you post some code together with the lay-out of your tables, so 
we can take a look at it.

HtH

Imar


At 05:38 PM 5/21/2002 +0100, you wrote:
>I am also trying to write a search engine for a database.
>
>I want to search the database using a form with txtbox for  athfname,
>athsurnam and club . I want to then bring up all records for that athlete-
>times , meeting, date etc all of which are in thedb.
>
>I have managed to do this by an ASP page with athlete name , but as soon as
>I try and use the form I get errors-at the moment the closing Wend or End if
>
>the dns is indoortrial and the table outdoor. I would also like to search
>for the same info from a table named indoor.
>
>Any help appreciated
>
>Charles