refresh after selecting from Combo109

  • Thread starter Thread starter Garry
  • Start date Start date
G

Garry

Hi all, I have this event procedure after update on my form

Private Sub Combo109_AfterUpdate()
Me![SalesTaxRate] = Me![Combo109].Column(1)
Me![BusinessUse] = Me![Combo109].Column(2)
Me![CatagoryDescription] = Me![Combo109].Column(3)
Me![SubCatagory] = Me![Combo109].Column(4)
End Sub

How can I get the form to refresh after selecting from Combo109

ps it does show correct information but only after closing and then
reopening the form

regards, Garry
 
Instead of populationg the boxes after the combo box is updated, simply make
the control source of the boxes equal to the relevant combo column.
e.g. set control source of SalesTaxRate to
=[Combo109].Column(1)
 
Back
Top