textbox indicator

  • Thread starter Thread starter newbie via AccessMonster.com
  • Start date Start date
N

newbie via AccessMonster.com

Without setting the required property = true; is there a way that when a user
begins entering data in a certain textbox - they are requested to fill in 3
other textboxes?
 
Example... Field1 controls Field2/Field3/Field4

Try using the AfterUpdate of the Field1...

If Not IsNull(Field1) Then
MsgBox "Must enter data in fields 2-4"
End if

Add this code to the OnExit for Field2 and Field3 and Field4 respectively...

Private Sub Field2_Exit(Cancel As Integer)
If Not IsNull(Field1) Then
Beep
MsgBox "Must have entry"
Cancel = True
End If
End Sub

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
There are 10 types of people in the world.
Those who understand binary, and those who don't.
 
Back
Top