Required field based on combo box selection

  • Thread starter Thread starter AccessIM
  • Start date Start date
A

AccessIM

Is it possible to require certain fields to be populated based on the choice
in a combo box?

I have a combo box on a form that populates a field called [Reason] in a
table. If the user chooses, for example, "Left Early" for the reason I want
the [TimeOut] field to be required and a msg box to pop up telling the user
the need to fill in that field. However, if the user chooses "Sick" for the
reason from the same combo box, the [TimeOut] field is not necessary and not
required.

Any help is appreciated as I am just barely at a beginner level when it
comes to writing code. Thank you in advance!
 
AccessIM said:
Is it possible to require certain fields to be populated based on the
choice
in a combo box?

I have a combo box on a form that populates a field called [Reason] in a
table. If the user chooses, for example, "Left Early" for the reason I
want
the [TimeOut] field to be required and a msg box to pop up telling the
user
the need to fill in that field. However, if the user chooses "Sick" for
the
reason from the same combo box, the [TimeOut] field is not necessary and
not
required.

Any help is appreciated as I am just barely at a beginner level when it
comes to writing code. Thank you in advance!
Click to expand...

You could use the form's BeforeUpdate event (or BeforeInsert if you're
adding a new record instead of updating an existing one) to test the
contents of the [Reason] field, then based on that check the [Time Out]
field and cancel the BeforeUpdate/BeforeInsert event if necessary:

If (Me.cboReason = "Left Early") Then
If IsNull(Me.txtTimeOut) Then
MsgBox "This field is required"
Me.txtTimeOut.SetFocus
Cancel = True
Exit Sub
End If
Endf If

Of course, use your own control names here. Check Access help for
information about using the BeforeUpdate/BeforeInsert events.

Carl Rapson
 
That worked great! Thank you so much.

Carl Rapson said:
AccessIM said:
Is it possible to require certain fields to be populated based on the
choice
in a combo box?

I have a combo box on a form that populates a field called [Reason] in a
table. If the user chooses, for example, "Left Early" for the reason I
want
the [TimeOut] field to be required and a msg box to pop up telling the
user
the need to fill in that field. However, if the user chooses "Sick" for
the
reason from the same combo box, the [TimeOut] field is not necessary and
not
required.

Any help is appreciated as I am just barely at a beginner level when it
comes to writing code. Thank you in advance!
Click to expand...

You could use the form's BeforeUpdate event (or BeforeInsert if you're
adding a new record instead of updating an existing one) to test the
contents of the [Reason] field, then based on that check the [Time Out]
field and cancel the BeforeUpdate/BeforeInsert event if necessary:

If (Me.cboReason = "Left Early") Then
If IsNull(Me.txtTimeOut) Then
MsgBox "This field is required"
Me.txtTimeOut.SetFocus
Cancel = True
Exit Sub
End If
Endf If

Of course, use your own control names here. Check Access help for
information about using the BeforeUpdate/BeforeInsert events.

Carl Rapson
Click to expand...
 
Back
Top