Madate Users to enter data in Textbox before proceeding to record on form

[Haleakala17]

All,

I am requesting if anyone knows a way (VBA script, etc) to make it mandatory for a user to enter data in a textboxes in a form before proceeding to the next record on a form? I know I am able to do this in the table by selecting the value "Yes" in the Required area in the General Tab but I was wondering if there is a VBA script you can enter it in a form instead.



On attachment is an Access Database in winzip. In the __Property form, I want to make it madatory for users to enter data in the County Shapefile Gross Acres, Township, Mineral Severance Tract, and Unit name fields before proceeding to a new record. If data is not entered in these textboxes for these field, then a person will not be allowed to go to the next record.

Thank you for your time.

Haleakala17

[pbaldy]

One way:

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

[Haleakala17]

pbaldy,

Thanks for the website but unfortunately the VB script did not work.

[pbaldy]

Since you haven't posted your code and I have no idea what "did not work" means, I don't know what the problem might be.

[Haleakala17]

Sorry about that, code is below.

If Len(Me.State & vbNullString) = 0 Then
MsgBox "You need to fill out State
Cancel = True
Me.State.SetFocus
End If
End Sub

I got this code from the website you sent me http://www.baldyweb.com/BeforeUpdate.htm . I changed the control name to State from SomeControl.

[pbaldy]

And how does it not work? The only way it wouldn't is if no changes had been made to an existing record, but a new record couldn't be saved without it.

[Haleakala17]

You are absolutely correct, I had made no changes to an existing record. Thank you very much. I apologize for the confusion.

[pbaldy]

No problemo!