Form on mouse move event?

[hfl]

Yes, I know... That's why I said in post #9 that I had explained my problem poorly and edited my posts, again I am very sorry.

Will look into different forms for the forms with many buttons but I still want users to be able to quickly be able to look at status of the equipment with the color codes green, yellow and red, can you do that with cascading combo boxes?

 

[isladogs]

I expect you could put that as a combo box field but it would have to be as text (GREEN, RED etc)

Suggest you do some research into cascading combo boxes here at AWF on Google

I'm going to drop out of this thread now as I am very busy with other tasks.
Good luck with your project

 

[static]

You don't need to paste in the click events. Generate them when the form opens.

Private Sub Form_Open(Cancel As Integer)
    For Each c In Controls
        If Left(c.Name, 5) = "btnID" Then
            c.OnClick = "=MouseUI(""" & Mid(c.Name, 6) & """)"
        End If
    Next
End Sub

Public Function MouseUI(btnID As String)
    DoCmd.OpenForm "InstrumentInfo", , , "[InstrumentList.ID]= " & btnID
End Function

 

[hfl]

@Static

Thanks a lot, that worked perfectly and saves me a lot of time