Requery syntax

  • Thread starter Thread starter Grant
  • Start date Start date
G

Grant

Hey all,
I have a form with a combo box that after a selection
runs a query based on the selection and then displays the
results in a subform. The subform isn't refreshing the
information. I know that the reason why is that the
subform needs to requery. MS help on the subject is kinda
real vague. I know that this is a common question but
haven't found the answer I need yet.

Thanks in advance,

Grant
 
refresh the subform when the AfterUpdate event of the
combo box fires:

Sub [comboBox]_AfterUpdate

'refresh the subform
me.[subform_name].requery

End Sub
 
Back
Top