Retrieve Value From other table

[jeremie_ingram]

I have created a simple system to track member information. It does include a photo on the form, and everything works better than I had hoped. Now what I would like to do is store the directory path in a table, and then use it in the code to pull up the photos.

Currently, the photos are "Lastname Firstname.jpg" and I have them all in C:\temp. I call the proper file and by assigning the fields to a string value like:


Dim strPht As String
Dim strPICName As String

strPICName = Me.LName & " " & Me.FName & ".jpg"
strPht = "c:\temp\" & strPICName
Me.Image59.Picture = strPht

I have created a form and table to store the directory path so that they can change it without having to get into the code, but I cannot figure out how to reference it.

tblPIcPath
-PicDir

The form simply displays the only field in the tblPicPath and allows them to enter the value (like C:\temp).

I would like to do things.

1. Restrict multiple entries into the tblPicPath (which I am sure I can do with a little creative form design).
2. Reference the only entry in the VB code above to call the entry into a string value.

Hope this makes sense.

 

[KeithG]

use the dlookup function to retrieve the path.