Select Query on Continuous Form

[SurveyorinVA via AccessMonster.com]

Good afternoon,

I have created a continuous form that has the following query has a record
source:

SELECT tblProjects.ProjectNumber, tblProjects.ProjectName, tblPTasksWO.
TaskNumber, tblPTasksWO.TaskName, tblPTasksWO.WOSetupDate, tblPTasksWO.
WOApproved, tblPTasksWO.WOID
FROM tblPTasksWO INNER JOIN tblProjects ON tblPTasksWO.ProjectID =
tblProjects.ProjectID
WHERE (((tblPTasksWO.WOApproved)=0))
ORDER BY tblPTasksWO.WOSetupDate;

Everything displays great. When I add some lines to the continuous form to
make it more appeasing to the eye, I notice that the query is generating an
extra row with no data. Is there a trick to let it display only those
records that have data and not the next blank record?

Thanks,
Chris in Virginia

 

[Jason Lepack]

Good afternoon,

I have created a continuous form that has the following query has a record
source:

SELECT tblProjects.ProjectNumber, tblProjects.ProjectName, tblPTasksWO.
TaskNumber, tblPTasksWO.TaskName, tblPTasksWO.WOSetupDate, tblPTasksWO.
WOApproved, tblPTasksWO.WOID
FROM tblPTasksWO INNER JOIN tblProjects ON tblPTasksWO.ProjectID =
tblProjects.ProjectID
WHERE (((tblPTasksWO.WOApproved)=0))
ORDER BY tblPTasksWO.WOSetupDate;

Everything displays great. When I add some lines to the continuous form to
make it more appeasing to the eye, I notice that the query is generating an
extra row with no data. Is there a trick to let it display only those
records that have data and not the next blank record?

Thanks,
Chris in Virginia

On the properties of the form click on the "Data" tab and the property
labelled "Allow Additions" set it to no.

Cheers,
Jason Lepack

 

[tobesurveyor via AccessMonster.com]

Thanks for your help
CF

Good afternoon,

[quoted text clipped - 19 lines]
On the properties of the form click on the "Data" tab and the property
labelled "Allow Additions" set it to no.

Cheers,
Jason Lepack