Query will not show values in the popup form

[patentinv]

Hi,
I have a popup form called Labor that is working perfectly fine, what i mean is that it is getting populated with data from the query I built using a single table called PrimaryBid_Master. However I have had to add many fields to this table before invoking a query on it, now I'm running close to the 255 field max limitation.
So I have created a new table called Labor_Primary with all the fields that I need and took them out of the PrimaryBid_Master table freeing up about 50 fields.

The query I made combines 2 tables: table1=PrimaryBid_Master table2=Labor_Primary, they are linked by a common field called invoice#.
But now when I’m in the PrimaryBid_Master form and click the command button to go to the popup form Labor non of the values that were populating the popup form from the primaryBid_Master form work, they were working fine the only thing I changed was the popup forms record source to the new query I built.
Here is a print screen of the new query I built using 2 tables, and I also show the old query that works fine using 1 table. http://www.roofmart.net/query1.asp

Maybe you can see some thing I did wrong; do I need some type of filter to fetch the fields? When I open the new query there is no data/values in it.

Thanks--I appreciate any help.

 

[neileg]

Because you have an inner join, you must have matching invoice numbers in both tables. Possible problems are:
1. There are no matching numbers
2. Different datatype in each table
3. Different datatype in the form control
4. Form control not populated
5. Form not open when the query runs

Other problems that may or may not have a bearing on your problem:
1. Don't use symbols in your object names, eg invoice#
2. Your structure sounds horrendous if you are approaching 255 fields in a table