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
- Private Sub Combo1_AfterUpdate()
- DoCmd.OpenForm "frmOrg", acNormal, , "[strOrgName]= '" & Me![Combo1] & "'"
- End Sub
Your helph is highly appreciated.
Regards,
Syed