how to disable command button when any field of form is empty?

[moonrb]

Hi, i am making A database. In this db there are many form with command buttons. Each command button executes many queries. These command buttons will not work properly if any field of the form remains empty. so how can i disable or inactive the command button when any field of form is empty?

[ADezii]

There are several ways to accomplish this, and this approach is simply one of them:

1. For any Form Field that must contain a Value, set the Tag Property of that Form Field to 'Req' (Required).
2. Execute the following Code which will:
   1. Loop thru every Control in the Form.
   2. If the Control has a Tag Property = Yes, and if the Value in this Control is Empty (NULL), set the Value of a Boolean Variable (blnFldEmpty) to True and exit the For...Next Loop.
3. The last Code Line will check the Value of this Variable (True/False) then set the Enabled State of the Command Button appropriately (Enabled/Disabled).
   

   Dim ctl As Control
   Dim blnFldEmpty As Boolean
    
   blnFldEmpty = False     'Initialize
    
   For Each ctl In Me.Controls
    If ctl.Tag = "Req" And IsNull(ctl) Then
      blnFldEmpty = True
        Exit For
    End If
   Next
    
   Me![cmdTest].Enabled = Not blnFldEmpty

[moonrb]

THANK U SO MUCH FOR YOUR REPLY BUT i NEED Whenever i click command button in a form that executes many queries at a time, it(command button) should check all the fields of the form filled up or not? if filled up then the command button should work otherwise not and beside the empty field should appear a message like this -"this filled cannot be empty". My command button name is "POST". PLZ GIVE ME ANOTHER SOLUTION WITH VB CODE.

[ADezii]

1. This is not what you indicated in your first Post.
   

   how to disable command button when any field is empty

2. Everything that you need is indicated in my Reply with a slight adjustment:
   

   If Not blnFldEmpty Then
     'Execute Code
   End if