Dear Sandra, When you filter a form you select a recordset. When you filter a second time you filter on the recordset and not and the basic selection of your form.
With the pop-up screen you have to unselect the filter and it will work. ----- Original Message ----- From: Sandra Maroney To: [email protected] Sent: Friday, December 02, 2005 8:05 PM Subject: [Access VBA Central] Filtering a Form from a Pop Up Form I have a data entry form with a button that can be clicked so that the user can check to see if any new cases have been loaded for him. The ID number on the popup form and the ID number on the data entry form would be the link. When the pop up form is displayed, it will have a list of ID's, as well as several other fields. I want the user to be able to double click on a particular ID and the form behind this popup will filter for that ID. So in the "on double click" property of the ID field, I have a macro that opens the main form and in the where expression, I have "[ID]= [Forms]![frmNewCases]![ID] I can get it to work the first time I apply the filter,but the next time I apply the filter, it brings up the previous ID. I am unfiltering the main form so that all of the records are available, but it still doesn't work. What am I doing wrong? Please help! Sam Maroney ------------------------------------------------------------------------------ YAHOO! GROUPS LINKS a.. Visit your group "AccessVBACentral" on the web. b.. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. ------------------------------------------------------------------------------ [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/KIlPFB/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessVBACentral/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
