Printable View
i dont know whether this is possible or not, that why i intend to post up here..
If let said i have 2 access form, Form A and Form B. When certain criteria have fullfill in Form A, Form B button will be disable, is this situation can happen?
i have wrote some code, but dont know how to continue...
[VBA]
Private Sub disableButton(frm As Form)
Dim ctl As Control
For Each ctl In frm.Controls
If StrComp(ctl.Name, "xxx") Then
'intend to disable the button here
Exit For
End If
Next ctl
End Sub
[/VBA]
Can't you just use this?
[vba]
ctl.Enabled = False[/vba]
ya i have tried that before, but it seem like this object properties does not support in this situation.http://vbaexpress.com/forum/images/smilies/think.gifQuote:
Originally Posted by Norie
Have you tried...?
[VBA]Me.ControlName.Enabled = False [/VBA]
i should said that i call the function in Form A but intend to disable button in form B...so i think cant use Me.xxxx right?Quote:
Originally Posted by xCav8r
Right, but you reference it using Forms or Form. I forget the exact syntax.
okie..i have figure out the solution. Actually very easy, i just forgot the syntax out of sudden, here is my solution.
[VBA]
Dim frm As Form
Set frm = Forms!yourForm
frm!yourButtonName.Enabled = False
[/VBA]
slchslch roxrox!!
so sorry i think i made a mistake here....this code just working on those active form , which mean if the form still have not active yet(not yet open), this code doe not work.
my question is , is there a way to control those inactive form components?http://vbaexpress.com/forum/images/smilies/banghead.gif
You would probably have to open the forms.