Query returns one too few records

[Frank Reichenbacher]

The following query returns records based on the check box field "shpRecChk"
which is on subform, subfrmtblShipRec, form, frmBioBase. The datasource for
subfrmtblShipRec, is tblShipRec, linked to the parent frmBioBase
(datasource, BIOBASE).

SELECT BIOBASE.newACCT_NO, tblShipRec.shpAcctNo, tblShipRec.shpMxDate,
tblShipRec.shpRecChk
FROM BIOBASE INNER JOIN tblShipRec ON
BIOBASE.newACCT_NO=tblShipRec.shpAcctNo
WHERE (((BIOBASE.newACCT_NO)=forms!frmbiobase!ACCT_NO) And
((tblShipRec.shpRecChk)=-1))
ORDER BY tblShipRec.shpMxDate DESC;

This query always returns one less than the actual number of checked boxes
on the subform.

What am I missing?

Frank

 

[John Vinson]

This query always returns one less than the actual number of checked boxes
on the subform.

What am I missing?

The Query isn't searching the subform - it's searching the table upon
which the subform is based. I suspect that the record that's being
missed is still open for editing, and has not yet been written to
disk. If you move off the subform, do you get the correct number?