Can I copy and paste automatically in forms?

[KMPLTD]

I have a photo database and, once I've entered the PhotoName in the
appropriate box, I would like it to magically appear in the link box that
contains the path to the photo. Eg: c:\My Documents\My Photos\[PhotoName].jpg

 

[John Vinson]

I have a photo database and, once I've entered the PhotoName in the
appropriate box, I would like it to magically appear in the link box that
contains the path to the photo. Eg: c:\My Documents\My Photos\[PhotoName].jpg

Set the Control Source of that textbox to

= "c:\My Documents\My Photos\" & [PhotoName] & ".jpg"


John W. Vinson[MVP]