How to use a FileInfo control to add a filename to an Access database

[rodgerm]

I'm trying to add both text and a picture filename to an Access database. The actual .jpg file is stored separately in another folder. I want to use a File control in classic ASP to do this. If I create a page for the text fields and a separate page for the File control, everything works fine but the users are confused by having to go to two pages. Ideally, they would use the Browse button of the File control to select their picture then the picture's filename would be passed down to the "ImageLink" field in the database Insert SQL command. Any ideas? Here's my two sections of code:

Country:

Description:
(255 char. max)

Price:
Numbers only with optional decimal point

Your Name:

Contact Info:
(255 char. max)

More Info:
(255 char. max)

Picture Filename:
Do not include spaces in the filename
Be sure to include extension (.jpg)

Second page code:

Please select picture to be saved for this item:

[Lost User]

Why are you asking the user for a filename when all you need is the upload selector? Once the image is uploaded to the server you have the filename which you can then add to your database.