data entry before closing

[kpryan]

Hi
I am looking for a way to stop lazy staff from closing a form before they have entered all data
I want a message box to appear warning them to fill in this text box(s) and that the form will not close until its done. I have made the form a modal form.
In this way the database will be useless until they complete all text boxes.

Many thanks,

KP

 

[fneily]

First, on the property sheet of the form, set Cycle to Current Record. This'll prevent them from going to a new record by tabbing and saving the data all ready there. So, you'll create a command button to Save the record. You can do this with the command button wizard. Then you can go to the code of the button (Property sheet, On Click) and write some data entry validation for the controls you want. Using an If statement and using the MsgBox function, you can put out a message stating which controls are not filled in. And using the SetFocus property of a control, you can place the cursor in the control that needs data.
If you have problems coding, post your code. Someone will probably help.

 

[TheAceMan1]

or you can use the forms [blue]Before Update[/blue] event to validate textboxes of interest have required data!

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[Pampers]

Hi kpryan,

You could do something like this:

If Trim(Me.Textbox1) & "" = "" then
Msgbox("Hey lazy worker, you have to set a value for Textbox1...")
me.Textbox1.setfocus
exit sub
end if

Pampers
Keeping it simple can be complicated