Button Help

[CJ]

Hi, here's the code i'm using for a button that takes me
to a specific directory on the harddrive.
-------
Private Sub Command3_Click()
Dim X As String
Dim y As Variant





'Y = fHandleFile(X, WIN_NORMAL)
y = fHandleFile("O:\wg_staff\CP Command
Post\Training\1_CERT", WIN_NORMAL)

End Sub
--------

It works just fine. But if I wanted to change the location
on the harddrive to where this button points I would have
to open up the code and edit it myself.
Now i'm trying to make this code user friendly. How can I
make it so that someone with no Access knowledge can click
a couple of buttons and select the location of where they
want the button to point? Do I make any sense? Thanks!
..

 

[none]

Make it so that they can enter the path n2 a table...then
pull that value from the table...that way they dont have
to remember it all the time and they can reset it at n e
time...

 

[CJ]

Ok, but how would I go about telling the vba code to look
at a particular field in a particular table?

 

[Ted]

-----Original Message-----
Ok, but how would I go about telling the vba code to look
at a particular field in a particular table?

You can use the DLookup() function.