inputbox, check for record, copy record...HELP!!!!

[lin]

Okay, here I am again. I have one large table (1900 records). I want to have an input box appear to capture a social security number. Then I want to locate and display the appropriate record on a page (not a form). Finally, I want to copy the displayed record (just a couple of fields) to another table.

Please help! This is due in three days.

Thanks in advance.

 

[DMac]

I assume you know the coding side so the only problem bit of SQL might be where you are "copying" the data (I'm assuming you mean inserting the data as a new row in another table);

INSERT INTO tblTestInsert ( Field1, Field2 )
SELECT Field1, Field2
FROM tblTest
WHERE SocialSecurityNo="01234";

 

[lin]

Actually I thought I knew the code but it's not working properly (or rather, consistently).

Can you help?

Thanks!