show text at focus

[JustinDB]

I need some help with my DB

This is my database cotroller


the next and back button work fine. the trouble i have is with the bleu balls when you focus on one of the balls a text must come to the text field. i used a label and an caption code but i dont get it to work i still need to click for it appears. And thats what i dont whant because when you click another form i beiing opened.

Please assist i thik this is a real challange

 

[JustinDB]

Please help me if anyone knows a salution

 

[mikebaldam]

If Me.NewRecord = True Then
Me.MYIMAGENAME.Visible = False 'replace MYIMAGENAME with the name of your object
else
Me.MYIMAGENAME.Visible = True
End If

 

[JustinDB]

the solution

tanks for the help but that wasn't what i meant.

i worked the whole day to figure it out and it's quit simple exually

als default information heb ik een cloc

Private Sub Form_Timer()
Me!Ilabel.Caption = Format(Now, "ddd hh:mm:ss")
End Sub

TIMERINTERVAL MUST BE SET TO 1000 BELOW TIMER IN ORDER TO MAKE IT WORK

this shows the day and the time in hours:minutes:seconds

when going over one of he balls i use this code

Private Sub ball1_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
Me!label.Caption = "Text wanted"
Me.TimerInterval = 0
End Sub

afcourse the timer intervall has to be set to 0 else the clock starts again after 1 sec then all you have to do now set the following code to this place so when you no longer with your mouse over the ball button the timer is set back and the time will start running again.

Private Sub Details_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
Me.TimerInterval = 1000
End Sub