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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top