Query returns one too few records

  • Thread starter Thread starter Frank Reichenbacher
  • Start date Start date
F

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
 
This query always returns one less than the actual number of checked boxes
on the subform.

What am I missing?
Click to expand...

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?
 
Back
Top