subforms & buttons

skate

Registered User.
Local time
Today, 16:09
Joined
May 22, 2002
Messages
136
I have a subform showing a continuous list of records. I want to create a button that links to another table, but is only enabled when there is a numeric value in one of the subform's fields. Now if I put this button in the subform it works great, but when I do the same thing in the main form, the button stays either enabled/disabled depending on the value in the first highlighted record. I want this to change as I highlight diff records. Help! It's so ugly now b/c the button is in the subform and I have to "simulate" the look of a datasheet.
 
In the subforms On Current event....

If Me.MyField = Whatever Then
[Forms]![MyMainForm]![MyCommandButton].Enabled = True
Else
[Forms]![MyMainForm]![MyCommandButton].Enabled = False
End If
 

Users who are viewing this thread

Back
Top Bottom