After Update Alteration

[Bob]

--
I changed my Combo Box Row Source from
SELECT ServiceID, ServiceInfo, Rate, ynMonthly FROM tblServiceInfo ORDER BY
ServiceInfo;
to This
QryDailyRate:
SELECT tblServiceInfo.ServiceInfo, tblServiceInfo.Rate
FROM tblServiceInfo
WHERE (((tblServiceInfo.ServiceInfo) Is Not Null) AND
((tblServiceInfo.ynMonthly)=False))
ORDER BY tblServiceInfo.Rate DESC;
Now when I select a record in the drop down list it does not select it for
me, What do I have to alter in the After Update to get the record to
show..Thanks For any Help..Bob



Private Sub cbServiceInfo_AfterUpdate()

If cbServiceInfo.value = "" Or IsNull(cbServiceInfo.value) = True Then
Exit Sub
End If

tbServiceID.SetFocus
DoCmd.FindRecord val(cbServiceInfo.value), , True, , True, acCurrent, True
End Sub

 

[Baz]

Previously your row source had 4 columns, now it has only 2, so my guess is
that your BoundColumn, Column Count and Column Widths properties need
changing to reflect this.

 

[Bob]

Thanks Baz I did change the Column widths , but just when I click on my
selection nothing happens......Bob