Queries and Listboxes

[h_rainier]

Dear Community:

This is my first post, and I am sorry if it is a bit repetitive. I have read quite a few entries on this in this website, as well as in others, but I cannot understand the language of the explanations. So, please, if you respond, please pretend you are dealing with a high school graduate with no programming background, but who is eager and ready to learn. Step-by-step, please! I tried to attach the file, but it is larger than the forum allows.

I am building a database that compiles several types of information in a table. That information is:

- Operation Type (there are 10, listed in a table named "OP")
- State (there are 27, listed in in a table named "UF")
- Citation to a Legal document (text, 100 chars)
- Notes (100 chars)
- Variation (checkbox, y/n)
- Legal Language (memo)

I have a form ("content"), with a button that opens up another form ("QF2", pop-up) asking for a state (listed in a listbox called UFlist) and an operation (OPList). Both lists are extended. I would like a query to feed off of the user selection in that form. Here's what I have done.

I created a query (MainQuery), and entered the following in the operation field criteria: [Forms]![QF2]![OpList]. I also entered [Forms]![QF2]![UFList] in the "Or" category. Ideally, I should be able to pull information from all states regarding one type of operation, or all operations in one state.



I get nothing but blank results when I make my selection and run the query. Why?! Even when I select all states and all operations, nothing comes through. Do I have to enter some VB language somewhere to get this to work? Can you explain where and what exactly?

Thank you so much for your input, and remember, I am challenged, but I learned all I know so far on my own...

h_rainier

[RayMilhon]

Without looking at your query or database I am making a couple of presumptions here. My comments are based on those presumptions. First I'm betting that your query uses inner joins something like

Select a.*,b.* from a inner join b on a.id = b.id

When you do this the field joined must be present in both tables. If the link isn't there in 1 table no record is pulled. You have 6 tables If one of those tables does not have any matching record your query will perform as you stated returning 0 records. Secondly if all tables have records but the field you're linking on does not match between the two tables again you will return 0 records. You will only return a record if the fields linked on have records in the other table that match.

[RayMilhon]

That last part should have been "have records in both tables that match"

[h_rainier]

Ray:
Thank you for such a quick response. I am trying to attach the file so you can take a look at it, if you have time.
I'm also trying to make the change you suggested.

Rainier

[h_rainier]

Ok, I looked at the SQL view of the query, and it shows this:

SELECT Content.Operation, Content.State, Content.Citation, Content.[Legal Language], Content.Variation, Content.Notes
FROM Content
WHERE (((Content.Operation)=[Forms]![QF2]![OpList]));



I'm not sure how to link the table to the form, or the query... Maybe that's what's missing. I created two tables to populate the State (UF) and Operations (OP) fields, and I also used that table to populate the listboxes.... I'm sorry, I'm trying to be more direct and open, but I'm not sure how I can do that!!!

[RayMilhon]

Here's the problem your combo box is a multi select combo box. When using a multi select combo box the selected elements are in a collection when you use the criteria Forms!QF2!oplist your getting the value not the collection and the value is blank so you're getting 0 records. I rarely use multi-select combo boxes or listboxes so someone else would be better qualified to help you. Last time I used one was at a previous employer and I don't have access to the code I used.
Maybe someone with more familiarity can point you in the best way to do this.