Tabbed Database Problem

[dmkennard2]

Hi,
I have a tabbed database that on one of the tabs has a link to a picture. Each time i change the record i am looking at the picture for that record updates automatically.
This is causing errors if certain users scroll through the records to fast.
Is there a way of having the picture update only when the tab is selected?

Thanks
Dazz

 

[missinglinq]

If by "scroll through the records to fast" you mean using the mousewheel, simply disable it!

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[Remou]

Here is a suggestion for displaying an image according to the tab selected. It assumes that the 'image' is a path to an image.

    Select Case Me.tabMainTab.Pages(Me.tabMainTab).Name
        Case "pgeAddressContact"
            <...>
        Case "pgePhotoDetails"
            DisplayImage Me.frmPhotos.Form.imgPhoto, Me.Photo

        Case Else
            <...>
    End Select

DisplayImage is from Microsoft:

http://support.microsoft.com/kb/285820

 

[dmkennard2]

I have disabled the mouse. I will try the code.

Thanks
Dazz

 

[dmkennard2]

Where do i put this code?

Dazz

 

[Remou]

I used it for a tab control with serveral pages. It ran in the On Current event of the form, to allow a user to page through looking at the photos. You will also need code in the On Click event for the photo page.