Setting a file extension for a linked Diagram with a Image Frame

[sailinxtc]

I am using a image frame to display a paint file and as each record changes
the picture changes with the record. The picture file is the same name as
the Primary Key. Everything works fine with the exception it wants the .bmp
extension on the file name or Primary Key. I basically set a control source
equal to the Primary Key. Am I missing something or is there a way to force
the Image Frame to use a default file extension without a lot of code ?

These are linked files and am using a relative path if that helps.

 

[Evi]

Put the file extension in another field and concatenate the fields in your
query

eg
MyPicPath & MyFileExtensions
You can use an Update query to set all the file extensions to .bmp and set
the Default value of the field to ".bmp" for future entries. Although you
could put this into your code, using a field name means that you could have
the option to add different types of files when you want to.


Evi