refresh after selecting from Combo

  • Thread starter Thread starter Virgin
  • Start date Start date
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
 
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
my combo boxes 2
Make a sub form visible with a combo box selection 4
Auto fill from a combo box 1

Back
Top