I invoked the combo-box wizard today, telling it to use a 4-table
union query as a row-source for the combo-box it was assisting
me in building. The error I got was without number and stated,
"Data cannot be retrieved from the source you have selected.
You must select a different table or query to continue in the wizard."
just after I chose the query named
qryAuthsOwnersAddnlOwnersLienholders4OneCar.
Have any of you ever seen that error message in A97 before?
I was able to successfully build the combo-box manually. Each
time I tried to use the query to build it, I failed.
The query runs fine, returning the desired records anytime its
launched. And, the manually constructed combo-box works
fine.
Here is the SQL for the union query...
SELECT [AddnlOwnrFName] & " " & [AddnlOwnrLName] & " " &
[AddnlOwnrAddr] & " " & [AddnlOwnrCity] & ", " & [AddnlOwnrState] & "
" & [AddnlOwnrZip] & " " & "(" & [AddnlOwnrCounty] & " county) " &
Format$([AddnlOwnrPhone],"(@@@) @@@-@@@@") & " " &
IIf([Corporation]=True,"(corporation)","(person)") AS Item,
tblVehicleJobs.VehicleJobID, "X" AS OLAX, tblAddnlOwnrs.AddnlOwnrID AS
RecID
FROM tblVehicleJobs INNER JOIN tblAddnlOwnrs ON
tblVehicleJobs.VehicleJobID = tblAddnlOwnrs.VehicleJobID
WHERE tblVehicleJobs.VehicleJobID=GetCurrentVehicleJobID ();
UNION SELECT [LienHolderName] & " " & [LienHolderAddr] & " " &
[LienHolderCity] & ", " & [LienHolderState] & " " & [LienHolderZip] &
" " & "(" & [LHCounty] & " county) " &
Format$([LienHolderPhone],"(@@@) @@@-@@@@") & " (corporation)" AS
Item, tblVehicleJobs.VehicleJobID, "L" AS OLAX,
tblLienHolders.LienHolderID AS RecID
FROM tblVehicleJobs INNER JOIN tblLienHolders ON
tblVehicleJobs.VehicleJobID = tblLienHolders.VehicleJobID
WHERE tblVehicleJobs.VehicleJobID=GetCurrentVehicleJobID ();
UNION SELECT [OwnerFName] & " " & [OwnerLName] & " " & [OwnerAddr] &
" " & [OwnerCity] & ", " & [OwnerState] & " " & [OwnerZip] & " " &
"(" & [OwnerCounty] & " county) " & Format$([OwnerPhone],"(@@@)
@@@-@@@@") & " (corporation)" AS Item, tblVehicleJobs.VehicleJobID,
"O" AS OLAX, tblOwners.OwnerID AS RecID
FROM tblVehicleJobs INNER JOIN tblOwners ON tblVehicleJobs.OwnerID =
tblOwners.OwnerID
WHERE tblVehicleJobs.VehicleJobID=GetCurrentVehicleJobID ();
UNION SELECT [AuthCompany] & " " & [AuthAddr] & " " & [AuthCity] & ",
" & [AuthState] & " " & [AuthZip] & " " & "(" &
Format$([AuthPhone],"(@@@) @@@-@@@@") AS Item,
tblVehicleJobs.VehicleJobID, "A" AS OLAX, tblAuth.AuthID AS RecID
FROM tblVehicleJobs INNER JOIN tblAuth ON tblVehicleJobs.AuthID =
tblAuth.AuthID
WHERE tblVehicleJobs.VehicleJobID=GetCurrentVehicleJobID ();