Access 2007, SQL Server 2008, In development not production,
Not sure which Forum is best so I posted here.
Problem:
I am joining an Entity (person or corporation) to a piece of Real Property using a join table.
dbo_Property Property Table
dbo_Entity Person or Corporation Table
dbo_PropertyEntity Table Joins dbo_Property to dbo_Entity
The following query runs when you click on the down arrow of a combo box located on the Property Form. The query runs fine and selects the correct information for you to choose from. The user can see the Entity Name and Address to verify they are selecting the correct Entity. When they select an Entity the Combo box places the EntityID PK into the join table just fine. However if I just place the cursor in the combo field and try to type a user name it won't jump to the user. I must scroll down to find the person and there may be thousands. The problem is not the query. The question is when you populate a combo box from a query, does it somehow disable the type and jump process?
Code:
SELECT dbo_Entity.EntityID, IIf([dbo_Entity]![LastName]<>"",[dbo_Entity]![LastName] & ", " & [dbo_Entity]![FirstName],[dbo_Entity]![NonPersonEntity]) AS Name, [dbo_EntityAddress]![EAddress1] & ", " & [dbo_EntityAddress]![EAddress2] & ", " & [dbo_EntityAddress]![ECity] & ", " & [dbo_EntityAddress]![EState] & ", " & [dbo_EntityAddress]![EZip] & ", " & [dbo_EntityAddress]![EAddressType] & ", " & [dbo_EntityComm]![EPhone] AS Address
FROM (dbo_Entity INNER JOIN dbo_EntityAddress ON dbo_Entity.EntityID = dbo_EntityAddress.Entity_EntityID) INNER JOIN dbo_EntityComm ON dbo_Entity.EntityID = dbo_EntityComm.Entity_EntityID;
I can’t find any articles or posts that directly address this.
Thanks,
Fred