Make a second combo box appear

  • Thread starter Thread starter john2171
  • Start date Start date
J

john2171

Hi,

How would one make a second combo box display detail
values from the first combo box? Example, if I pick a
person's name from the first combo box, I would like a
second combo box to return the different account numbers
for that specific name.

Thanks,

John
 
John,
Hopefully you are somewhat familiar with writing VB or SQL code in events,
because that seems the easiest...

In the 'AfterUpdate" event for combo box #1, you would write something like:
dim sq as string
sq = "Select AccountNum from dbo.Accounts Where Name = " &
me.ComboBox1.column(0)
me.ComboBox2.RowSource = sq

Let me know if you need more details.
(e-mail address removed)
Andy
 
Back
Top