Need to disable a command button until a certain field is populated

[dgrimes]

I have a badge form with a print button at the bottom. I would like this print button disabled until certain fields above are completed. I have text fields and I have radio button (frame) fields connected to other tables. I cannot figure out where or how to write the code that will let me accomplish this. I do not need all the fields on the page complete so I will probably have to name each one. Any help you can give would be appreciated.



Please be specific on where to put the code. I am still learning the ins and outs.

Thank you.

[NTC]

one can use either the visible property or the enable property

ie. me.CommandButtonName.visible = False

depending on the user interface experience will determine which event to trigger its property change

to start the command button in a certain state at the change of the form's record use the form's On Current event

[dgrimes]

But how would I tie that to a certain field? I would like the button to be grayed out until a certain field is populated. Once data is put into that field the button would be enabled again.

[NTC]

in the certain field's After Update event you would add code: me.CommandButtonName.enabled = true

of course preceding this one must make that button enabled = false ; you can do that as its core property or in the On Current event of the form itself

[Missinglinq]

If you were talking about a single Required Field, it would be simple! But since you have multiple required Fields, you'd have to not only check that the current Control is populated, in its AfterUpdate event, but that all other required ones are populated, before Enabling the Command Button. Also, the users would not have any indication of which Controls were required...if they knew this, they'd have filled them in!

Probably much better would be checking all of the Required Fields/Controls at one site, the OnClick event for the Command Button, and telling the users why the print button isn't working.

In Form Design View

1. Hold down <Shift> and Left-Click all Required Controls
2. Go to Properties – Other
3. In the Tag Property enter ReqField

Now, in the Form's Code Module

Private Sub cmdPrintButtonName_Click()

Dim ctl As Control

For Each ctl In Me.Controls
  
  If ctl.Tag = "ReqField" Then
     If IsNull(ctl) Then
       MsgBox "Following Field is Required: " & vbCrLf & vbCrLf & ctl.Name
       Exit Sub
     End If
  End If

Next ctl

'Code to Print goes here

End Sub

Hopefully, after getting the Messages telling them why the print button isn't working, they'll learn which ones are required!

Linq ;0)>