B
Bob V
Can this be added to "tblHorseDetails.Invocing=No" So as The Yes Records are
eliminated
tblHorseDetails.Invoicing is a Yes/No Field
Thanks if you can help me with this...............Bob
recHorseOwners.Open "SELECT OwnerID,OwnerPercent FROM tblHorseDetails" _
& " WHERE HorseID=" _
& val(tbHorseID.value) & " AND OwnerID > 0 ORDER BY OwnerID ",
CurrentProject.Connection, adOpenDynamic, adLockOptimistic
eliminated
tblHorseDetails.Invoicing is a Yes/No Field
Thanks if you can help me with this...............Bob
recHorseOwners.Open "SELECT OwnerID,OwnerPercent FROM tblHorseDetails" _
& " WHERE HorseID=" _
& val(tbHorseID.value) & " AND OwnerID > 0 ORDER BY OwnerID ",
CurrentProject.Connection, adOpenDynamic, adLockOptimistic