open file dialog box in access 2000

[MS Access 2000]

Hi,
I'm working on a form where I want to be able to open the "open file" dialog
box, select a file, and save the filename into a textbox on the form.
I don't have much experience in Access or VB or anything but I figure things
out as I go, so I'm pretty much working blind.
I followed instructions here:
http://support.microsoft.com/default.aspx?scid=kb;en-us;303066 and got it to
work (dialog box opens, I select a file and click "open", filename and path
appears in the textbox), but when I close the form it removes the file name
from the textbox, and when I open the form again the textbox is blank.
Can somebody help me please?
Thanks,
Miriam

 

[Douglas J. Steele]

The only way you can save the selected value is to store it somewhere:
controls on forms don't have any way to store values themselves.

That usually means binding the textbox to a field in the form's recordset,
although you could conceivably store the value in an INI file, or in the
registry or even in a custom property of the database.