Hi – newbie here (using Access 97 & FP98),

Ok – I’ve got 2 ASP pages up and running – the 1st is a summary with a submit button on each record, when I click submit it opens another page with extra details on that individual record.

What I want to do now is use a form with 2 drop down menus, a few radio buttons and an ’open text’ box.

I’ve managed to get one drop down menu to work, but I can’t work out the format/code to include another drop down menu/radio buttons.

I can’t get my head around how it actually works with an SQL statement.
Does each drop down menu refer to an individual part of the SQL statement and when all the boxes are filled out and you submit, the ‘whole’ SQL is executed?

Could someone please explain this to me?
I would appreciate some sample code so I could taylor it for my needs.
Also how do you set up SQL to allow a user to enter ‘free text’ and if there is a match it returns those records.
I’d want the free text box to be used in conjunction with the drop downs.

Thanks in advance – any help would be most appreciated – Stephen.