tab control page events

[ClydeData]

In a tab control on one of my forms I want to record who is entering what page, (this is in order that we know what is being used and to build a faster form where data of highest priority loads on first open

On experimenting with the events of each page in the tab control
On mouse move, triggers constantly (I would require to use an if then else statement with a dlookup to avoid duplicates)

On Click, On Mouse Up ; On Mouse Down do not trigger the code???

Any thoughts on the best place to put this code (should it be on mouse move with an if then else)

Thanks

Jimmy





Dim db As DAO.Database
Dim rs As DAO.Recordset
Set db = CurrentDb
Set rs = db.OpenRecordset("tblWhoIsUsingWhat", dbOpenDynaset)
rs.AddNew
rs![JobID] = Me.JobID
rs!Screen = "Main Job Screen"
rs!Page = "Costs"
rs!Computer = GetComputerName()
rs!User = GetCurrentUserName()
rs!DateUsed = Now()

rs.Update

 

[TheAceMan1]

How are ya ClydeData . . .


The [blue]On Change[/blue] event fires whenever you switch pages. I believe this would be better. In any case I don't see how you'll be able to tell someone who's just clicking pages for the fun of it.

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]