Not sure but it sounds like the filtering process is
done during the Form_Load event -- which only happens
the first time the Form is loaded. Which means if you
don't Unload the form prior to refreshing it then the
filter is not reset. But that's only a guess.
--- Sandra Maroney <[EMAIL PROTECTED]> wrote:
> 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! DSL Something to write home about.
Just $16.99/mo. or less.
dsl.yahoo.com
------------------------ Yahoo! Groups Sponsor --------------------~-->
Most low income households are not online. Help bridge the digital divide today!
http://us.click.yahoo.com/I258zB/QnQLAA/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/
