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 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/ms_access/ <*> 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/
