i really need to be able to edit the record,
ive done an html form and asked it to fill the boxes ie name, description etc were the id = whatever.

all boxes are filled exept the file field as i know it wont,
but i thought i could just have the file box and upload an image eveerytime u want to edit, ya know make it easyer on me.

but when i hit submit, if i use select * from table were ID(autofield) = & ID & kinda thing. i get Data type mismatch in criteria expression
if i change id to name i get bof or eof no datafound type error
i have looked n looked and bashed my brain and have come to a dead end in a project thats so far taken me a week.

any help editing the record will be very much appreciated