not go to next screen without entry

[one armed man]

i am editing the user interface for operators.

here is the issue:
operators are entering data but sometimes forget to put the part serial number. they then go to the entry.

this is what i want to do:
the operator will not be able to go the next screen (complete the entry) unless they enter the part serial number. where and what should i enter that will prevent the issue?

much thanks.

 

[ScottGem]

This is a forms issue, not a queries issue.

What you need to do is test if the control is Null before you go to the next screen. Since you don't say what they do to get to the next screen its hard to help further. I suggest reposting in the Forms forum with more detail.

 

[ScottGem]

Pat,
Doesn't the required property on the table level only kick in when the user tries to save the record? I think a problem here is what meant by "the next screen". This could mean a different page on the same form. In that case moving to the next screen wouldn't test for required fields.

 

[ScottGem]

That's another way to handle it.

 

[one armed man]

next data entry

Thank you for your replies.
What I mean by "next screen" is the same form but new data entry. The operator clicks on the asterisk button and it gives the blank fields to enter new data for the next product. So yes, same form.
I'll try your suggestion now.
Thanks again.

 

[ScottGem]

"Next screen" implies a different form or different part of the form. What you are referring to is a new record. In that case the Required property will work for you as going to a new record means saving the current one. But if a filed with a required property is not filled in, then it won't allow you to save the record.

 

[one armed man]

Okay. I'll follow the above code. I don't understand the below. Can you elaborate what exactly is going on.

If IsNull(Me.SomeOtherField) Then
Msgbox "some other message"
Me.SomeOtherField.SetFocus
Cancel = True
End If
End Sub


thanks.

 

[ScottGem]

Its testing a control (SomeOtherField) to see if its Null. If it is, then it displays a message and sets the focus back to that field.