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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create and Open Word Document From Access & asociate with 2 Fields 3
Autofilter for Access 2003 (like in Excel) 1
Field to Field dilemma 3
validation for one field based on another 1
Field Appearance Based On Another Field 2
Access Automatically Send a notification email once a record is added 0
Autopopulated field in form 2
Passing field from one form to another 1

Back
Top