This is a reformat of your recordsource SQL
Code:
SELECT dbo_HPOHD.HHPO
,dbo_HPOHD.*
,dbo_HPODT.HDJOB
,dbo_HPODT.HDDESC
,dbo_JHEAD.JHPART
,dbo_UHPOHD.TOCUID
,dbo_JHEAD.JHJOB
,dbo_HPODT.HDPO
FROM (
(
dbo_HPOHD INNER JOIN dbo_HPODT ON dbo_HPOHD.HHPO = dbo_HPODT.HDPO
) INNER JOIN dbo_JHEAD ON dbo_HPODT.HDJOB = dbo_JHEAD.JHJOB
)
INNER JOIN dbo_UHPOHD ON dbo_HPODT.HDPO = dbo_UHPOHD.TOPO
WHERE (((dbo_HPOHD.HHPO) = [Forms]![PONUM].[PPCPO]));
Please tell us what each of these tables represents so we have some feel for your data.
dbo_HPOHD
dbo_HPODT
dbo_JHEAD
dbo_UHPOHD
This dbo_HPOHD.* represents all fields in table dbo_HPOHD -- so you don't need this dbo_HPOHD.HHPO also????
Did you watch the video http://www.datapigtechnologies.com/f...mtoreport.html ?
Again, tell readers in plain English, what you are trying to accomplish.