open file dialog box in access 2000

  • Thread starter Thread starter MS Access 2000
  • Start date Start date
M

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
 
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.
 
Back
Top