Combo Box Problem with FAQ

[yakdogs]

I have been working with the FAQ on this but still having problems.

First combo (category) feeds second combo (subcategory)

This is the SQL that I am putting in the row source in the properties form. I keep getting nothing in the second box.

What I have written is below:

SELECT tblsubcategory.strSubCat FROM tblSubCategory WHERE Category =Forms![frmEdit_Dent_part]![Category].value

Can anyone see what I am doing wrong?

Your help is greatly appreicated.

 

[gusbrunston]

[tt]
Hi:

The problem be in more than the SQL statement. (I sometimes try to test an SQL in the query design view, to see if it works. Sometimes I design a query, and simply cut and paste the SQL statement from the query.)

Here is a link to an FAQ on Microsoft that clearly shows how to synchronize two combo boxes, using the sample Northwind database that ships with Access:

http://support.microsoft.com/support/kb/articles/Q209/5/95.asp

You'll notice the code goes in the After Update event of the first combo box.
[tt] Gus Brunston - Access2000[/tt] Intermediate skills.