Common Dialog Control result output

[sagsh]

Hi

I have a problem with the attached database - It has a form with a common dialog control which works fine until you select the file.

The form asks you to select a picture file and I am trying to get it to output the result to a field, instead what happens is that the form's background image changes to that of the selected file. I have checked everything and cannot see where my code/form design has gone wrong!

could someone please help me with this it is driving me mad!

sagsh

 

[WayneRyan]

sagsh,

In your code for the Command button:

MyFile = Mid(strPath, InStrRev(strPath, "\") + 1)

MyFile contains the name of the file.
strPath contains the path AND the file name.

It is assigned to a picture field, but you can assign it to a textbox:

Me.SomeTextBox = MyFile
Me.SomeTextBox = strPath

Wayne