Access List Boxes

Here's the scenario
I have two listboxes. ONe shows a list of topis and once choosen gives a new list in the other textbox.

I have used this code but it doesn't seem to work...
suggestions?

SELECT tblHeading.HeadingID, tblSubHeading.HeadingID, tblSubHeading.SubHeadingID, tblSubHeading.SubHeadingName FROM tblSubHeading INNER JOIN tblHeading WHERE tblSubHeading.HeadingID = Me.Heading_list

Also this is all in an attmept to have a database that i can store paragraphs in and pick and choose which paragraphs i want to have in a report shipped to excel. Any suggestion on how to do this?

THanks

Try

SELECT tblHeading.HeadingID, tblSubHeading.HeadingID, tblSubHeading.SubHeadingID, tblSubHeading.SubHeadingName FROM tblSubHeading INNER JOIN tblHeading ON tblSubHeading.HeadingID= tblHeading.HeadingID WHERE tblSubHeading.HeadingID = [Forms]![formName]![Heading_list]


You where missing the On the specifies how your inner join works and you made an incorrect reference to you listbox on the form


The easiest way to do this is to create a query you want you second list box to be created off, put the query in as the data "Row Source" and in the GotFocus event of the second listbox put "SecondListBoxName.requery" to refresh the second list box with your new info.