B
Bob Vance
This is what I have so far but sometimes Horses have not got a HorseName yet
so I would like the Father,Mother,Sex to show instead!
idHorse = Nz(Me.tbHorseID, 0)
If idHorse <> 0 Then
strHorse = Nz(DLookup("[HorseName]", "tblHorseInfo", "[HorseID]=" &
idHorse), "")
Else
strHorse = ""
End If
------------------------------------
But if "[HorseName]" = ""
strHorse = Nz(DLookup("[FatherName]", "tblHorseInfo", "[HorseID]=" &
idHorse), "") &
strHorse = Nz(DLookup("[MotherName]", "tblHorseInfo", "[HorseID]=" &
idHorse), "") &
strHorse = Nz(DLookup("[Sex]", "tblHorseInfo", "[HorseID]=" & idHorse), "")
so I would like the Father,Mother,Sex to show instead!
idHorse = Nz(Me.tbHorseID, 0)
If idHorse <> 0 Then
strHorse = Nz(DLookup("[HorseName]", "tblHorseInfo", "[HorseID]=" &
idHorse), "")
Else
strHorse = ""
End If
------------------------------------
But if "[HorseName]" = ""
strHorse = Nz(DLookup("[FatherName]", "tblHorseInfo", "[HorseID]=" &
idHorse), "") &
strHorse = Nz(DLookup("[MotherName]", "tblHorseInfo", "[HorseID]=" &
idHorse), "") &
strHorse = Nz(DLookup("[Sex]", "tblHorseInfo", "[HorseID]=" & idHorse), "")