Joe,
The easiest method would be to evaluate after input or update, that flagges
the field required.
If IsNull(me.input_type) then
' Do nothing.
Else
' Make value required.
Msbox("You must select a value for Control.Name), vbCritical, strDB_Title
End If
--- On Fri, 4/3/09, Joe <[email protected]> wrote:
From: Joe <[email protected]>
Subject: [Access VBA Central] One Field Required based on another Field
To: [email protected]
Date: Friday, April 3, 2009, 10:56 AM
I have a form that has a drop down field called Input_Type that has a list for
Project or Discretionary.
I also have another field on the form that is Capitalizable Y/N.
I need to make the Capitalizable Y/N drop-down required if they select Project
from the Input_Type drop down.
What is the best way to go about this using VB?
[Non-text portions of this message have been removed]
