Incomplete form

[jinz]

I have a customer form with the typical data

E.g customer first name customer last name address, etc

However how do in access have a pop up message if the user doesn't complete the form like say for example they do not fill in the 'customer last name' field?thanks

[pbaldy]

One way is to make the field required in the table. Another:

http://www.baldyweb.com/BeforeUpdate.htm

[Missinglinq]

There are multiple ways to do this, as Paul indicated, but I generally use the following:

Set the Tag Property, for all Controls that you want to have checked, to Required (no Quotes, please.)

To set the Tag Property for multiple Controls, in one fell swoop:

1. Go into Form Design View
2. Holding down <Shift> and Left clicking on each Control in turn, to select it.
3. Go to Properties – Other and enter your value (Required) in the Tag Property; it's the last Property under Other.

Now, add this code behind your Form:

Private Sub Form_BeforeUpdate(Cancel As Integer)
Dim ctl As Control

For Each ctl In Me.Controls
    
       If ctl.Tag = "Required" Then
         If Nz(ctl,"") ="" Then
           Cancel = True
           Msgbox ctl.Name & "  is a Required Field and Must Have Data Entered"
           ctl.SetFocus
           Exit Sub
         End If
     End If
 Next

End Sub

You should now be set!

Linq ;0)>

[jinz]

wow, thanks very much guys, on other quick question please

I have a field called customergender, a user can only type "M" or "F", however it still works if I type a random letter in such as "v"

Do you know the "event on change" so when the select the field and change/type in a random letter I want to have a pop up message saying something like "You can only type "M" for male or "F" for female?

thanks very much.

[pbaldy]

I might use a combo box with those two selections and its limit to list property set to yes. You can also use code in the before update event of the control or form:

http://www.baldyweb.com/BeforeUpdate.htm

[Missinglinq]

Private Sub customergender_BeforeUpdate(Cancel As Integer)
 If Me.customergender <> "M" And Me.customergender <> "F" Then
  MsgBox "You can only type M for male or F for female!"
  Cancel = True
  Me.customergender.SelStart = 0
  Me.customergender.SelLength = Len(Me.customergender)
 End If
End Sub

This expansion of the example Paul gave will do it, but using a Control to limit the user to M or F, as he suggested, would really be preferable, to my way of thinking. In addition to a Combobox, you could also use an Option Group with two Option (aka Radio) Buttons.

Linq ;0)>

[Missinglinq]

Please don't send Private Messages to members as part of a continuing thread, post back here, instead!

I have no idea what

"still works ^ I don't want that"

means! The code I gave you should prevent the user from successfully entering anything other than M or F, popping up a MessageBox, as you requested, and then selecting the erroneous entry, allowing them to press M or F, as instructed. If that doesn't work for you, you need to explain your problem better.

Linq ;0)>

[jinz]

solved thanks all!

[pbaldy]

The first declares a variable to be used to represent a control. The second tests the current control in the loop to see if is either Null or contains a zero length string (""). The third sets focus to that control if it has either.

[jinz]

solved please delete this thread thanks.

[jinz]

thanks guys a mod/admin can delete this thread now thanks

[Missinglinq]

We don't 'delete' resolved threads! Your simple acknowledgment that a response has resulted in a resolution of your problem is adequate! Resolved threads are important in that they provide a resource for people searching for answers to identical or similar problems!

Glad we could help!

Linq ;0)>