Combo box Problem

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

Guest

Can anyone help with this frustratingly easy problem?

I have a table with two columns: CourseCode and CourseName. I have a form
with a bound combo box to the table showing the course codes. I have an
unbound text box that I want the course description to appear in that relates
to the course code selected in the combo box.

I have tried various bits of code in the OnChange property of the combo box
and different criteria in the record source properties of both the combo and
text boxes, but nothing seems to work.

This must be really easy, but I just cannot fathom it. Any suggestions?
 
Add the course name as the second column in the actual combo box. You can
have it shown or not by setting the column width to a value or to 0. Set the
control source property of your text box to

=[ComboBoxName].[Column](1)
 

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

Locking a combo box 4
Retain combo box order 1
cascading combo box 20
Combo box returning wrong value 2
Search combo box 2
Combo Box case sensitivity 0
OnChange from Combo box 3
Formatting combo box drop-down list 1

Back
Top