Requery syntax

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
 
M

misha

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

Sub [comboBox]_AfterUpdate

'refresh the subform
me.[subform_name].requery

End Sub
 

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

requery continuour subform 11
subform based on external SQL won't requery 1
Repaint vs Refresh vs Requery 1
listbox requery 2
Need to use F9 to requery in subform 7
Requerying a subform from another subform 2
Syntax on Sync'd Subform 5
Requery combo box in subform 5

Top