Combos and subforms

  • Thread starter Thread starter Katherine
  • Start date Start date
K

Katherine

Hi I'm quite new at this and I'm trying to put a combo
box on a form in the header and be able to update the
data in the subform when I choose something else in the
combo box. The combo box looks up people and the subform
shows their records. If I make the subform based on a
query linking the combo box contents and the records, how
can I get Access to refresh or update the records
displayed in the subform when a different person is
selected in the combo box?

Any help will be appreciated, I think I've had this
problem before but I can't remember how I resolved it or
if I did at all.

Thanks.
 
Add this code to the Combo Boxes "On Change" Procedure: -

Me.SubForm.Requery

Note that "SubForm" is the name of the Sub Form you are
wanting to update, adjust this name accordingly.

HTH


Tony C
 
Back
Top