refresh after selecting from Combo

V

Virgin

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
 
A

Allan Murphy

Garry

Using the got focus event of Combo109 enter the following
docmd.requery "Combo109"

Allan
 

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

Similar Threads

refresh after selecting from Combo109 1
Image Database form 1
Trouble Filtering a Sub Form With Combo Box Options 2
filter on combo box possible? 1
Access Sub form opens before the main form in MS Access 0
Make a sub form visible with a combo box selection 4
my combo boxes 2
Auto fill from a combo box 1

Top