Row Source question

[VTXscooter]

Hi.
I poste this on the table forum but that might have not been the correct place. I have been reading allot about cascading combo boxes here but I am still stumped.

I have a form with several drop dpwn lists in it. I want the choice of each on to narrow the choices of the next drop down list.

I have see a few examples on this site on how this is done but at this point I dont understand how to write the information. I have taken what another person had posted and dont really get what to do next. Do I paste the info in the rowsource box and then build the query? The example I saw had expr1 and expr2 in the querys so I was lost.
Thanks, Joe

1st drop down list row source
SELECT DISTINCTROW tblProjects.ProjectID, tblProject.Poject FROM tblProjects ORDER BY tblProjects.Project;

2nd drop down list row source
SELECT DISTINCTROW tblLocations.LocationID, tblLocations.Location FROM tblLocations WHERE (((tblLocations.ProjectID)=[Forms]![frmMain]![cboProjects])) ORDER BY tblLocations.Location;

 

[mcadle]

see table forum for reply.