Combo box not updating

  • Thread starter Thread starter Jeff Gilstrap
  • Start date Start date
J

Jeff Gilstrap

I have a combo box that lists all the customers for a
given sales rep. When I change the sales rep in the
form , the list in the combo box still has customers from
the previous rep. the combo box list doesn't update
unless I completly get out of the form and reopen it. The
sales rep form with the combo box is a subform of the main
sales rep form. Any easy fix for this?? I tried adding a
docmd.requery on click for the control with no succcess.
Thanks
Jeff G
 
Put a Me.ComboboxName.Requery step in the AfterUpdate event of the control
in which you select the rep.
 
Ken-
It didn't seem to like that- possibly because the rep
control is on the main form and the combobox that will not
update properly is on the subform. JG
 
Makes a big difference!

You'll need to modify the code slightly:
Me.Subform.Form.ComboboxName.Requery

where Subform is the name of the subform control (the control that holds the
subform), and Form is to be used literally.
 
Ken-
Bingo. Thanks for the help!!! JG
-----Original Message-----
Makes a big difference!

You'll need to modify the code slightly:
Me.Subform.Form.ComboboxName.Requery

where Subform is the name of the subform control (the control that holds the
subform), and Form is to be used literally.
--

Ken Snell
<MS ACCESS MVP>





.
Click to expand...
 
Back
Top