Private Sub btn01_Click()
ResetMe (ActiveControl.Name)
End Sub
Private Sub btn02_Click()
ResetMe (ActiveControl.Name)
End Sub
Private Sub btn03_Click()
ResetMe (ActiveControl.Name)
End Sub
Private Sub btn04_Click()
ResetMe (ActiveControl.Name)
End Sub
Private Sub btn05_Click()
ResetMe (ActiveControl.Name)
End Sub
Private Sub btn06_Click()
ResetMe (ActiveControl.Name)
End Sub
Private Sub btn07_Click()
ResetMe (ActiveControl.Name)
End Sub
Private Sub btn08_Click()
ResetMe (ActiveControl.Name)
End Sub
Private Sub btn09_Click()
ResetMe (ActiveControl.Name)
End Sub
Private Sub btn10_Click()
ResetMe (ActiveControl.Name)
End Sub
Private Sub btn11_Click()
ResetMe (ActiveControl.Name)
End Sub
Private Sub btn12_Click()
ResetMe (ActiveControl.Name)
End Sub
Private Sub btn13_Click()
ResetMe (ActiveControl.Name)
End Sub
Private Sub btn14_Click()
ResetMe (ActiveControl.Name)
End Sub
Private Sub btn15_Click()
ResetMe (ActiveControl.Name)
End Sub
Private Sub btn16_Click()
ResetMe (ActiveControl.Name)
End Sub
Private Sub btn17_Click()
ResetMe (ActiveControl.Name)
End Sub
Private Sub btn18_Click()
ResetMe (ActiveControl.Name)
End Sub
Private Sub chk01_AfterUpdate()
DisableMe (ActiveControl.Name)
End Sub
Private Sub chk02_AfterUpdate()
DisableMe (ActiveControl.Name)
End Sub
Private Sub chk03_AfterUpdate()
DisableMe (ActiveControl.Name)
End Sub
Private Sub chk04_AfterUpdate()
DisableMe (ActiveControl.Name)
End Sub
Private Sub chk05_AfterUpdate()
DisableMe (ActiveControl.Name)
End Sub
Private Sub chk06_AfterUpdate()
DisableMe (ActiveControl.Name)
End Sub
Private Sub chk07_AfterUpdate()
DisableMe (ActiveControl.Name)
End Sub
Private Sub chk08_AfterUpdate()
DisableMe (ActiveControl.Name)
End Sub
Private Sub chk09_AfterUpdate()
DisableMe (ActiveControl.Name)
End Sub
Private Sub chk10_AfterUpdate()
DisableMe (ActiveControl.Name)
End Sub
Private Sub chk11_AfterUpdate()
DisableMe (ActiveControl.Name)
End Sub
Private Sub chk12_AfterUpdate()
DisableMe (ActiveControl.Name)
End Sub
Private Sub chk13_AfterUpdate()
DisableMe (ActiveControl.Name)
End Sub
Private Sub chk14_AfterUpdate()
DisableMe (ActiveControl.Name)
End Sub
Private Sub chk15_AfterUpdate()
DisableMe (ActiveControl.Name)
End Sub
Private Sub chk16_AfterUpdate()
DisableMe (ActiveControl.Name)
End Sub
Private Sub chk17_AfterUpdate()
DisableMe (ActiveControl.Name)
End Sub
Private Sub chk18_AfterUpdate()
DisableMe (ActiveControl.Name)
End Sub bingo3.zip
Controls on tabular lists are not separate objects. There are single objects that repeat for each record on the list. With that said, you will have a hard time controlling certain objects on screen forms lists.
You can try Conditional Formatting for some of these controls. This is a built-in feature of Access and can control certain formats for certain controls.
For example.... you can Lock a control on a tabular record based on other field values in the record... but you've actually locked the control on all the records... you just can't tell (or see it) because you're focused on the single record. If you click to another record... it seems like that single control may be locked or not. Now... if you try to control the source of a combo box in a single record.... each time you focus on another record... ALL the visible combos will change their record source.
You might want to figure out a different method for your visualizations.
You can try Conditional Formatting for some of these controls. This is a built-in feature of Access and can control certain formats for certain controls.
For example.... you can Lock a control on a tabular record based on other field values in the record... but you've actually locked the control on all the records... you just can't tell (or see it) because you're focused on the single record. If you click to another record... it seems like that single control may be locked or not. Now... if you try to control the source of a combo box in a single record.... each time you focus on another record... ALL the visible combos will change their record source.
You might want to figure out a different method for your visualizations.
Scott C