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

Get the filtered results from a search

P: 30
Hi,
How I can get the filter ON on results from a search?
I am using MS Access 2000/2002. I do a search and it takes me to another form but instead of going to that particular record that I selected , it goes to the first record of the form and when I press Filter button, then it goes to the desired record.
I am using this code (with the help from this same forum)
Expand|Select|Wrap|Line Numbers
  1. Private Sub Combo1_AfterUpdate()
  2. DoCmd.OpenForm "frmOrg", acNormal, , "[strOrgName]= '" & Me![Combo1] & "'"
  3. End Sub
  4.  

Your helph is highly appreciated.
Regards,
Syed
Jan 14 '08 #1
Share this Question
Share on Google+
1 Reply


Rabbit
Expert Mod 10K+
P: 12,356
Please use code tags.

In the On Open event of the other form, have it set the FilterOn property to True.
Jan 14 '08 #2

Post your reply

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