Which Control Source is correct?

[floyd]

I have three different control source codes and none of them are working as they should.



This one allows the form to run... but I can't get the three list boxes to populate.

SELECT Item.[Input Date], Item.Item, Item.Description, Item.[File Location], Item.[File Name] 
FROM ((Item INNER JOIN (datAud INNER JOIN tblAud ON datAud.aud = tblAud.[Audience].Value) ON Item.InputID = tblAud.[Input ID]) INNER JOIN (datTopic INNER JOIN tbltopic ON datTopic.topic = tbltopic.Topic.Value) ON Item.InputID = tbltopic.InputID) INNER JOIN (datType INNER JOIN tbltype ON datType.type = tbltype.Type.Value) ON Item.InputID = tbltype.InputID;

The next two don't allow the form to pull up at all.

SELECT Item.[Input Date], Item.Item, Item.Description, Item.[File Location], Item.[File Name], datAud.aud, datTopic.topic, datType.type
FROM ((Item INNER JOIN (datAud INNER JOIN tblAud ON datAud.aud = tblaud.[Audience].Value) ON Item.InputID = tblaud.[Input ID]) INNER JOIN (datTopic INNER JOIN tbltopic ON datTopic.topic = tbltopic.Topic.Value) ON Item.InputID = tbltopic.InputID) INNER JOIN (datType INNER JOIN tbltype ON datType.type = tbltype.Type.Value) ON Item.InputID = tbltype.InputID;

SELECT Item.[Input Date], Item.Item, Item.Description, Item.[File Location], Item.[File Name], tblaud.Audience, tbltype.Type, tbltopic.Topic
FROM ((Item INNER JOIN (datAud INNER JOIN tblAud ON datAud.aud = tblaud.[Audience].Value) ON Item.InputID = tblaud.[Input ID]) INNER JOIN (datTopic INNER JOIN tbltopic ON datTopic.topic = tbltopic.Topic.Value) ON Item.InputID = tbltopic.InputID) INNER JOIN (datType INNER JOIN tbltype ON datType.type = tbltype.Type.Value) ON Item.InputID = tbltype.InputID;

I'm trying to get the multiple choice list boxes to work. I have been working on it since 6am.
Any help would be appreciated.

This is my form:



These are my relationships

[John_G]

Hi -

Please clarify what the select statements are record sources for - are they different versions for the Form Record Source (which is what they look like) ?

If when you say the form "does not pull up at all" you mean the form opens but is completely blank, it means there are no records for the form to display; in other words the Record source for the form (your select statements?) did not identify any records.

What is it you want the list boxes to contain? Your data structure indicates you should be using a form-subform arrangement, rather than listboxes. Also, what is it that you want the form to do? As you have it now, it won't do much more than display data.

[floyd]

Let me take these one at a time for you. (Thank you for the help before I get started)

Let me explain what I am trying to do and that may help.



This is my first shot at creating a database... and a relational database at that.

Please clarify what the select statements are record sources for - The statements are "record sources" in the input form for the purpose of:
1. Allowing the tblAud / tblType / tblTopic (tbl-databases) to access their associated data in the datAud / datType / datTopic areas (dat-databases)
2. Allowing the multi-list boxes to then associate and input the data from the form.

Are they different versions for the Form Record Source (which is what they look like - I believe the answer here is YES. Each of the three tbl-databases link to lists of common data.

If when you say the form "does not pull up at all" you mean the form opens but is completely blank - Blank meaning, there is no FORM. The only think I see is the header.

What is it you want the list boxes to contain? - Information from datAud / datType / datTopic

Also, what is it that you want the form to do? As you have it now, it won't do much more than display data. - The form currently correctly inputs information from only the Item database. I am wanting it to also associate and input information from the various input boxes.

I hope this helps me to explain.

Joe