form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any way to have informationentered automatically into two fields
after selecting an item from a drop down list?
 
If you are talking about retrieving values from this list box, then on the
after update event of the drop down list write the code

Me.Field1Name= Me.comboName.column(0)
Me.Field2Name= Me.comboName.column(1)

The column number is depended on the location of each field in the rowsource
of the combo, starting with location - 0.
 
Darla,
Include those 2 fields in your combo box (ex. a three column combo box)
Using the AfterUpdate event of the combobox use this sample code to
examine the values stored in column two and three of the combo, and update
your fields (ex. Field2 and Field3) accordingly.
Field2 = cboYourComboName.Coulmn(1)
Field3 = cboYourComboName.Column(2)
(combo box columns are numbered 0, 1, 2, 3, etc... so the second column
..Column(1), and the third column is .Column(2))
hth
Al Camp
 
Back
Top