SELECT countryid FROM tbl_UT_States WHERE State = client.User = "#form.FirstName# #form.LastName#"; client.User_First = form.FirstName; client.User_Last = form.LastName; client.User_Zip = form.ZipCode; client.user_org = form.Organization;