close form button with additional criteria

[woodpecker]

I have a form that after it is opened the fields are required to be filled in.
when they click the close button I want to make sure they have filled in the fields, if they click the close button before they start filling in the form it will close. Once the form is open I want it so the form cannot be close no matter what, until all the fields are filled in.
I am a beginner so I have limited VBA code skills.

I was thinking of either a select or IF statement

If Fname field null then
cmd.open.frmMailingList
else


close form

Help Please

[June7]

Do you mean the X Close? I would disable the X Close and use a Command Button control.

Code like:

Private Sub Command68_Click()
If Not Me.Dirty Then
    Cancel = True
    MsgBox "Enter data"
Else
    If IsNull(Me.Rate) Or IsNull(Me.RateID) Then
        MsgBox "Still missing data."
    Else
        DoCmd.Close
    End If
End If
End Sub

How does record even get created without data if data is required?

[woodpecker]

I disable the X this is the close command button.

This organization helps people with mental health issues and when people call and want to be added tot he mailing list we create a report run monthly of people to be added to the list. The employees are not diligent in recording people's information when filling out their daily log form, when they click the button that the person want to be added to the mailing list it opens the mailing list form. so I have created it so they have to record the info and not close the forms. The daily log reports show how the employees do not enter the info.

I will try the code you have supplied thank you

[woodpecker]

Do you mean the X Close? I would disable the X Close and use a Command Button control.

Code like:

Private Sub Command68_Click()
If Not Me.Dirty Then
    Cancel = True
    MsgBox "Enter data"
Else
    If IsNull(Me.Rate) Or IsNull(Me.RateID) Then
        MsgBox "Still missing data."
    Else
        DoCmd.Close
    End If
End If
End Sub

How does record even get created without data if data is required?

This is the table fields for the form. should I be using the name of one of these fields because it does not like (Me.Rate) The name of the form is frmMailingList

[June7]

I gave you example code. Use your object names where appropriate. Which fields are required - all of them?

[woodpecker]

Yes I figured that out and it works great thank you