Form Entry

  • Thread starter Thread starter DaveB
  • Start date Start date
D

DaveB

I have a form with 3 fields on it. When I select an option
from a drop down box in field 1, I would like certain
information to automatically fill into fields 3 and 4.

How do I go about setting this up?

TIA.

DaveB
 
Dave, you would use the afterupdate event of the combo box. Open the
property window for the combo(View/Properties from the main menu or
double-click it). Click the event tab an scroll down to the afterupdate
event. Click the ellipsis(...) to open the code window and type in
something like:

Private Sub cboMyCombo_AfterUpdate()
If Not IsNull(Me.myCombo) Then
Me.Field1 = "Hello"
Me.Field2 = "Goodbye"
End If
End Sub


Reggie
 
Back
Top