Access 2003 Left join between a Table and Query - Unable to select entrys from combo box

[Mke85]

Hello!

I have been beating my head off the table on this one and can't seem to come up with a work around or figure out why this is happening. I am some what new to access databases but here is what I am trying to do.

I have 3 tables which store information about Radios, Laptops, and Audio Equipment. Primary key in all of them is "Asset#" and a common field in all of the tables in "Type of Equipment". To view all the "Asset#"s together I created a Union Query. That worked fine!

Another form has been created called LoanDetails which displays information about all of the assets when selected from a combobox which uses the Union query as its row source. The combo displays all entries good. In the back ground I have this statment as the record source:

SELECT LoanDetails.LoanDetailsID, LoanDetails.LoanID, LoanDetails.ProductID, LoanDetails.Quantity, [Equipment Union Query].Expr1003, [Equipment Union Query].[Type of Equipment], LoanDetails.Notes
FROM LoanDetails LEFT JOIN [Equipment Union Query] ON LoanDetails.ProductID = [Equipment Union Query].[8W #];

The problem is I cannot select anything from my combo box. It lists all the entrys from the union query but nothing is selectable.

Thanks for the help!

 

[SkipVought]

hi,

Maybe part of your problem is that "I have 3 tables which store information about Radios, Laptops, and Audio Equipment" which you "view all the "Asset#"s together [when] I created a Union Query" when they are ALL "Type of Equipment".

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Mke85]

I created the three tables to seperate the different types of equipment stored within the database. Each table has different columns but shares similar columns such as "Type of Equipment", "Serial #", and "Model".

If this doesnt make much sense I can try and explain more..

 

[dhookom]

Tell us about more combo box properties. I think we have the Row Source but don't know any other data or event properties. Also, does the form allow editing?

Duane
Hook'D on Access
MS Access MVP