subform requeries on command button press??

[slenish]

Hi,

Ok what I have is a form where I built a search feature that runs a query when you press a search button. It works great but the results pop up in another window and im trying to make it so the results will pop up in the same window in a subform. I have a sub form already created and it seems to work when I select the information I want to find from a drop down box but for some reason i have to close the form and reopen the form to get it to requery. I want it to update or requery the sub form when I press a button in the main form, but every combination of code I can think of does not seem to be working. Any help on the matter would be great.

Thanks in advance.

[ADezii]

@slenish
To Requery a Sub-Form from the Parent Form:

Me![<Sub-Form Control Name>].Requery

[slenish]

Hi ADezii,

Thanks for the response. I am trying to get what you wrote to work but still having trouble. Where do i put the expression in the button onClick function? Also when you say sub-form control name do you mean just the name of the sub form or something else?

Thanks

[ADezii]

@slenish

Where do i put the expression in the button onClick function?

You can, among other Events.

when you say sub-form control name do you mean just the name of the sub form or something else?

The Name of the Sub-Form Control - not the Name of the Sub-Form contained within.