By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,337 Members | 2,084 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,337 IT Pros & Developers. It's quick & easy.

subform requeries on command button press??

100+
P: 283
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.
May 13 '10 #1
Share this Question
Share on Google+
3 Replies


ADezii
Expert 5K+
P: 8,638
@slenish
To Requery a Sub-Form from the Parent Form:
Expand|Select|Wrap|Line Numbers
  1. Me![<Sub-Form Control Name>].Requery
May 13 '10 #2

100+
P: 283
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
May 17 '10 #3

ADezii
Expert 5K+
P: 8,638
@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.
May 17 '10 #4

Post your reply

Sign in to post your reply or Sign up for a free account.