Hi Lee, we would need to see your query in design view in order to see what's amiss.

Donald I will attach a screenshot. The query is working fine, its now the product list I have is not showing up.

Based on this your query looks good as far as that field. I do see a red flag in the Name of that table "Inclusion/AddedT". The "/" could give you trouble throughout your application. You'll always need to make sure that table is enclosed in square brackets [ ].

Beyond that, verify that none of the criteria in the query is limiting the recordset such that none of the records it finds have "Need" indicated.

The query works fine after I fixed the joins when Richard pointed it out. Not sure why it wont show the needed option on the product list which is continuous form of course.

Create a new query with FirearmT, MagazineT & InclusionAddedT (with left joins)
Add each of the other tables one at a time testing after each is added until you find the Table that is breaking your query.

Kevin I shouldn't have put all that in the post I guess. But I fixed the query after Richard pointed out the joins. Query is fine, it is the product list which is a continuous form not showing the need options now.

To be clear, the form is not showing any records that have "Need" or a combo box on the form isn't showing the "Need" option?

The "Need" option is not showing up on the form Product List. Only the Included or Added products are showing up.

What is the Record Source of the Form?
Is there a Filter turned on?

alright let me see if i can explain what i just discovered. I have a form to enter my magazines. I then created a magazine list form with a continuous form. I normally just enter the firearm that the magazine goes and enter the data for that magazine and it goes into the list fine. But when I just enter the firearm and mag number needed it does not show up. I just discovered that I have to fill in every field in the mag form to make it show in the mag list form. I have never had to do that before. So basically i have to enter data in every field for it to work. Never had to do that before.

Lee

This might be a government conspiracy!!!!!   =O    (extreme sarcasm)

In line with Kevin's prior comment... usually if I have issues with queries like this, it's because the join properties are not correct.  Double click on each join line and make sure these are setup correctly.

These should say "show all records from MagazineT"

-Raymond

Every join coming from MagazineT is from Magazine T on the join options. There are 5 tables and all are the same. Like I say IT IS NOT  the Query it is working fine. Its the Product list that is the problem.

Alright. Raymond is the winner he solved it..IT IS A CONSPIRACY....I FIXED it. I rebuilt the continuous form from scratch again and it is now working.

Lee
Can you give us screenshots of your Product List Form in design view, specifically, the properties window of each tab.

And, if any text is cut off especially in the control source, filter, etc., either copy that content to a post or zoom in (shift-F2) and get a screenshot and if you have any kind of code or macros for the form that effects filters.

Likewise, similar property sheet and code/macro grabs for any filtering combos or buttons as well as fields that display (or are missing) the data your not getting.

I know it seems like a lot, but we'll need to see what you can see to point you in the right direction.

Don

Don
Thank you. I was able to solve it. I recreated the product list form from scratch and got it to work. Thank you everyone that has been trying to help me.