B
Bradley C. Hammerstrom
A2K(SP-3), WinXP
A form with a Picutre frame has a subform datasheet which lists the FileName
and PathName of each photo for the user to select. When the user clicks on a
record in the subform the photo (all jpgs) appears in the picture frame on
the main form using the OnCurrent event of the subform:
***code snipett***
'This line loads the Photo
Me.Parent![imgPhoto].Picture = Me![FilePath] & Me![FileName]
*****
This all is fine and good.
However when a user with a fast trigger-finger clicks on one record and then
quickly clicks in another row before the first photo appears, then Access
suddenly closes! I can't trap the error using MsgBox err.Description.
What's happening? How can I catch it before Access gives-up and closes?
Brad H.
A form with a Picutre frame has a subform datasheet which lists the FileName
and PathName of each photo for the user to select. When the user clicks on a
record in the subform the photo (all jpgs) appears in the picture frame on
the main form using the OnCurrent event of the subform:
***code snipett***
'This line loads the Photo
Me.Parent![imgPhoto].Picture = Me![FilePath] & Me![FileName]
*****
This all is fine and good.
However when a user with a fast trigger-finger clicks on one record and then
quickly clicks in another row before the first photo appears, then Access
suddenly closes! I can't trap the error using MsgBox err.Description.
What's happening? How can I catch it before Access gives-up and closes?
Brad H.