help setting up log in and query

[oliviera]

I have a form with 2 text boxes one for username another for pwd and an option box to select a module ) retriving data from a database called ict ,this should display the results when username and pwd are verfied according to the selected module (NW,SW or HW ) so how codes should they look like ? ...especially the querry .

Thanks
by oliver R

[jhardman]

I have a form with 2 text boxes one for username another for pwd and an option box to select a module ) retriving data from a database called ict ,this should display the results when username and pwd are verfied according to the selected module (NW,SW or HW ) so how codes should they look like ? ...especially the querry .

Thanks
by oliver R

please explain the database setup: what are the names of the tables and fields within the db?

First figure out the log in. If log in is incorrect, go back to the log in, otherwise open the db with something like this:

 query = "SELECT * FROM tabelName WHERE module = '" & request.form("modSelect") & "'"