View Single Post
  #2 (permalink)  
Old January 30th, 2008, 11:28 AM
mmcdonal mmcdonal is offline
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

I normally do cascading combo boxes like this on the On Change event of the first combo box:

Dim iPrimaryKey As Integer
Dim sSQL As String

iPrimaryKey = Me.Combo0
sSQL = "SELECT PKID, Name FROM tblCustomer WHERE [PKID] = " & iPrimaryKey

Me.Combo2.RowSource = sSQL
Me.Combo2.Requery

Does that help?

mmcdonal

Look it up at: http://wrox.books24x7.com