Variable Undefined using MS Access

[trs.net]

I'm getting this error (below). I've created a form where once the user clicks
ths submit button they are taken to a page that says "thanks for filling in
this form." The usrs information is sent to an Access databse table. ALSO, on
this page is cold fusion code that emails the users information to me. The
information is being sent to the Access db. However, on this "thanks page" I'm
receiving this error below telling me that a variable is undefined.

I figure Access is being finicky again. I just found out yesterday that when
using Access and sorting page data by #URL.EID# that I don't need the single
quotes. Damn that was frustrating. I'm hoping this solution is just as easy.

Here's my code (I've eliminated my password information but know that it is at
the top of this code below)

#Fname# #Lname# Date of Birth: #dob#

Parents'/Caregivers' Names:
#P1Fname# #P1Lname#
#Address1#
#City1#, #State1# #Zip1#
Home Phone: #Hphone1#
Cell Phone: #Cphone1#
Email: #Email1#

#P2Fname# #P2Lname#
#Address2#
#City2#, #State2# #Zip2#
Home Phone: #Hphone2#
Cell Phone: #Cphone2#
Email: #Email2#

Thank you!

</cfmail>
<cfquery>
INSERT INTO SSG (Fname, Lname, dob, P1Fname, P1Lname, P2Fname, P2Lname,
Address1, City1, Hphone1, Cphone1, Email1, Address2, City2, Hphone2, Cphone2,
Email2, HIprovider,"State1", Zip1, "State2", Zip2, A1, A2, A3, A4, A5, A6, A7,
A8, A9)
VALUES (#Fname#, #Lname#, #dob#, #P1Fname#, #P1Lname#, #P2Fname#, #P2Lname#,
#Address1#, #City1#, #Hphone1#, #Cphone1#, #Email1#, #Address2#, #City2#,
#Hphone2#, #Cphone2#, #Email2#, #HIprovider#,#State1#, #Zip1#, #State2#,
#Zip2#, #A1#, #A2#, #A3#, #A4#, #A5#, #A6#, #A7#, #A8#, #A9#)
</cfquery>



ERROR
-----------------------------------------------------------------
Variable FNAME is undefined.
The error occurred in D:\INETPUB\peer-projects\surveys\thanks.cfm: line 30
28 :
29 : Child's Name:
30 : #Fname# #Lname# Date of Birth: #dob#
31 :
32 : Parents'/Caregivers' Names:


Thanks in advance!

[paross1]

Wouldn't you want to scope your variables on your action page, such as #form.Fname# or #url.Fname# etc.?


Phil

[trs.net]

Phil, I'm not sure what you mean. The only part that isn'tworking is the automated email part.