refresh after selecting from Combo109

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
 
D

Dennis

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)
 
Top