[AccessD] Item Not Found In This Collection

Gustav Brock Gustav at cactus.dk
Tue Jun 8 11:20:57 CDT 2010


Hi Rocky

I'm out of ideas. I've never seen something similar.

/gustav


>>> rockysmolin at bchacc.com 08-06-2010 17:41 >>>
Gustav:

So I changed the set of the PODetail recordsets from:

'Set rsPODetail = db.OpenRecordset("Select * FROM tblPODetail WHERE fldPOHID
= " & Me.fldPOHID)
'Set rsPODetailNew = db.OpenRecordset("Select * FROM tblPODetail")

to:

Set rsPODetail = db.OpenRecordset("Select fldPODRevision, fldPODPosted,
fldPODTaxable, " _
    & " fldPODQuantityReceived, fldPODQuantityOrdered, fldPODDateRequired, "
_
    & "fldPODUnitCost, fldPODUOM, fldPODPartDescription, fldPODVendorPart, "
_
    & "fldPODPartNumber, fldPODLineNumber, fldPOHID, fldPODID " _
    & "FROM tblPODetail WHERE fldPOHID = " & Me.fldPOHID)

Set rsPODetailNew = db.OpenRecordset("Select fldPODRevision, fldPODPosted,
fldPODTaxable, " _
    & " fldPODQuantityReceived, fldPODQuantityOrdered, fldPODDateRequired, "
_
    & "fldPODUnitCost, fldPODUOM, fldPODPartDescription, fldPODVendorPart, "
_
    & "fldPODPartNumber, fldPODLineNumber, fldPOHID, fldPODID FROM
tblPODetail")
 
And that works.  But why?

Rocky





More information about the AccessD mailing list