Populating a combo box from another combo box

[Cachelot]

I want to populate the second combo box "cmdSubCategory" from the first combo box

"cmdCategory". I have placed the following code in the "Private Sub

cmbCategory_Change()" section..

Dim ListData As String
ListData = "SELECT [SubCategories].[SubCatID], [SubCategories].[SubCategory] FROM

SubCategories WHERE [SubCategories].[CatID]=" & cmbCategory & ";"
Me!cmbSubCategory.RowSource = ListData

This works fine if I use the mouse and select a Category but if I type in a

Category the cmdCategory gets filled in as I type but when I Press enter the

second combo box does not get populated. Any suggestions??

I really need the help...

 

[ntp]

Put this in the AfterUpdate event of your cmbCategory combobox.

ntp

 

[Cachelot]

Thanks for the help "ntp". I really appreviate it.

 

[redsand23]

Thanks for all of your help. I got it!!!