After Update Alteration

  • Thread starter Thread starter Bob
  • Start date Start date
B

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
 
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.
 
Thanks Baz I did change the Column widths , but just when I click on my
selection nothing happens......Bob
 
Back
Top