hi Ken,

Thanks for your response. I did try to follow as directed in the link that
you mentioned. But, my problem is not solved.

Let me try to be clear in what I'm looking for:

Say I have a table 'Category' with data as below:
CategotyID CategoryName
------------  ----------------
1               vb
2               C
3               sql server
4               office

Now, say I have two combo boxes. cbOne and cbTwo.
Now, when the form loads, I ahve all the category Id's prefilled in cbOne.
When the user selects a value for cbOne (say 2) then,
I want only (1,3, and 4) to be listed in cbTwo.

I tried to do this:
1. Set to rowSource for cbOne to Category table - CategoryID
2. Added the afterUpdate event for cbOne

Private Sub cbOne_AfterUpdate()
Dim strSQL As String
   strSQL = "select " & Me.cbOne
   strSQL = strSQL & " from Category"
   Me.cbTwo.RowSourceType = "Table/Query"
   Me.cbTwo.RowSource = strSQL
   Me.cbOne.Requery
End Sub    

3. Left the RowSource for cbTwo blank.

What this does is list only that which is selected in cbOne (i.e. 2) and not
what I'm expecting (1,3, and 4).

Am I missing something?

thanks,
cole