B
Bob
--
I have a Query linked to my form, I have a combobox drop down list with this
row source(SELECT qryAHOPF.Name, qryAHOPF.HorseID FROM qryAHOPF; ) that
shows my horses names, what would i need in After Update so it selects the
horse in the dropdown list
SELECT QryOwnerHorsePercent.OwnerID, qryHorseFinished.Name,
QryOwnerHorsePercent.HorseID, QryOwnerHorsePercent.OwnerPercent,
tblOwnerInfo.OwnerID, tblOwnerInfo.OwnerTitle, tblOwnerInfo.OwnerFirstName,
tblOwnerInfo.OwnerLastName, tblOwnerInfo.OwnerAddress, tblOwnerInfo.Phone1,
tblOwnerInfo.Phone2, tblOwnerInfo.Email, tblOwnerInfo.CellPhone
FROM qryHorseFinished INNER JOIN (QryOwnerHorsePercent INNER JOIN
tblOwnerInfo ON QryOwnerHorsePercent.OwnerID = tblOwnerInfo.OwnerID) ON
qryHorseFinished.HorseID = QryOwnerHorsePercent.HorseID;
..........Thanks Bob Vance
I have a Query linked to my form, I have a combobox drop down list with this
row source(SELECT qryAHOPF.Name, qryAHOPF.HorseID FROM qryAHOPF; ) that
shows my horses names, what would i need in After Update so it selects the
horse in the dropdown list
SELECT QryOwnerHorsePercent.OwnerID, qryHorseFinished.Name,
QryOwnerHorsePercent.HorseID, QryOwnerHorsePercent.OwnerPercent,
tblOwnerInfo.OwnerID, tblOwnerInfo.OwnerTitle, tblOwnerInfo.OwnerFirstName,
tblOwnerInfo.OwnerLastName, tblOwnerInfo.OwnerAddress, tblOwnerInfo.Phone1,
tblOwnerInfo.Phone2, tblOwnerInfo.Email, tblOwnerInfo.CellPhone
FROM qryHorseFinished INNER JOIN (QryOwnerHorsePercent INNER JOIN
tblOwnerInfo ON QryOwnerHorsePercent.OwnerID = tblOwnerInfo.OwnerID) ON
qryHorseFinished.HorseID = QryOwnerHorsePercent.HorseID;
..........Thanks Bob Vance