Sales Credit Card Reconciliation Shows Only 1 Record

[dbcTech]

If you are using Business! with Access 2007 there is a bug in Access
2007 with master/child links when a continuous subform is used. Access
tries to establish a master/child link although there should not be
one. This causes the Credit Card Reconciliation subform to display
only 1 record. To correct, add code at the end of the UpdateRecords
subroutine in the Credit Card Sales Register form to force the child
and master fields to nothing. This will then correctly display all the
credit card transactions. A code excerpt is below:

...
'Resort the data based on the last label selected. Get the location
of the hyphen.
'The left side is the field name and the right side is ASC or DESC
Dim hyphen As Integer, sortfld As String
If Not IsNull(.CurrSort) Then
hyphen = InStr(1, .CurrSort, "-")
sortfld = Mid(.CurrSort, 1, hyphen - 1) & " " & Mid(.CurrSort,
hyphen + 1)
sqlstmt = sqlstmt & " ORDER BY " & sortfld
End If

'Finally reset the subform record source
.RecordSource = sqlstmt

'ADD NEW CODE BELOW
'added v5.3.14.2 to handle Access 2007 problem with child/master
fields issue with a continuous subform
Me.CreditCardSalesRegisterDetails.LinkChildFields = ""
Me.CreditCardSalesRegisterDetails.LinkMasterFields = ""

End With

End Sub