Form submission to database

Hi.

I have created a database, a page to view the results and a form page.  However I cannot submit the form details to my database, I have been getting the following error;

"Error Type:
Microsoft VBScript runtime (0x800A01B6)
Object doesn't support this property or method: 'Bookingspage_form'
/example/Bookings_process.asp, line 18"

I actually created the form before the database but everything else works apart from this vital stage, can anyone help?

Regards,

Line 18 is:

Firstname=request.Bookingspage("Firstname")

After which I have the various other field names, Secondname etc.

Thanks for responding.

Regards,

E.

I am using ASP.  I thought I had to use the actual form file name of "Bookingspage"?

Hi.

Just to clarify, I am trying to create a form page which will save details to the database, so far  I have completed a form and a display page listing all items within the database.

However I am having a problem with my "process" page, as a result when I submit the form I am getting an error.  The error at the moment is:

"Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
/example/Bookings_process.asp, line 74"

Although the script on line 74 is: Connection.execute(sql) the script relating to the "INSERT" statement is earlier on the page and basically relates to all the input fields in the form.