textbox indicator

[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?

 

[Al Camp]

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.

 

[newbie via AccessMonster.com]

Thanks Al, thats really helpful