Field filled in automatically when info entered in another field?

  • Thread starter Thread starter stephen
  • Start date Start date
S

stephen

I want the user to select one of ten courses from a drop
down list (Field1), and when he/she does, the cost of the
course will automatically appear in another field
(field2). so that the info in both fields will be placed
in the underlying table).
What is the easiest way to do this?
Thanks in advance
 
Hi,


Have the combo box list based on the two fields (the course name, and,
hidden, the cost).


In the after update event of the combo box, do:


Me.OtherControl=Me.ComboBoxName.Column(1)


where 1 refers to the second column ( the first one is 0 ), which I assumed
was the one with the cost.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top