refreshing Subform Data

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

Hello, I have a form (frmOTinput) which has a subform
(frmSubform) and listbox.
The listbox contains department numbers and when you
select a new department the subform refreshes and shows
the historical record of who worked overtime in that
department and allows new entries. The problem I have is
that in this subform there is an entity "Employee" with a
drop down box which displays the names of the employees
in the department. This drop down box does not refresh
and shows the employees of the initial department
selected. If I push the F9 key it refreshes but I have
tried to use the SendKey command to various events to no
avail.
Thanks for any help you can offer.
 
Hi Setve, in the code that requeries the subform, include a line to requery
the combobox

e.g.

MySubFormControl.Form.Requery ' Requery the form in the subfrom control
MySubFormControl.Form.Employees.Requery ' Requery the employee combobox

Hope this helps,
Graeme.
 
Back
Top