How do I set up a value based on another box's value in access?

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

Guest

I have tried to figure this out for the last couple months and I can't - I
need help. I'm not much of a computer lingo talker- so, please forgive my
descriptions.
Is it possible:
To have 2 combo boxes and have the value of the second one base upon what
you select in box one. For example: The table is built with one field of
first names and one field for the last names. Is it possible when I select
the combo box and view the first and last name that the fist name goes in
combo box one and the last name AUTOMATICALLY pops up in the second box.
 
I have tried to figure this out for the last couple months and I can't - I
need help. I'm not much of a computer lingo talker- so, please forgive my
descriptions.
Is it possible:
To have 2 combo boxes and have the value of the second one base upon what
you select in box one. For example: The table is built with one field of
first names and one field for the last names. Is it possible when I select
the combo box and view the first and last name that the fist name goes in
combo box one and the last name AUTOMATICALLY pops up in the second box.
Click to expand...

If the first combo already is showing the First and Last Names, why do
you need a second combo to show that last name? Any reason you can't
use a regular text control?

In Combo1, set the control source property to [FirstName].
Make the column that shows the FirstName the bound column.
Use a text control, bound to the [LastName] field.
Set Combo1 AfterUpdate event to:
Me![TextControlName] = Me!Combo1.Column(x)
Where Column(x) is one less than the column number that contains the
Last Name. On a 2 column combo box, it would be Column(1).
 
Back
Top