I have a combobox and a listbox.My combobox requery and filter
the records in my listbox and it works fine.But after update my combobox,
I unable to remove the filter of listbox cause there is no option to showing
up all records in my combobox.How to add option all to mycombobox to
showing up all records in my listbox.

Thank's in advance.

You could try to requery for your combobox for the onchange event.

HTH
Roger

"rahmad" wrote:

> I have a combobox and a listbox.My combobox requery and filter
> the records in my listbox and it works fine.But after update my combobox,
> I unable to remove the filter of listbox cause there is no option to showing
> up all records in my combobox.How to add option all to mycombobox to
> showing up all records in my listbox.
>
> Thank's in advance.
>
>
>

see if this helps http://www.mvps.org/access/forms/frm0043.htm

Jeanette Cunningham

"rahmad" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have a combobox and a listbox.My combobox requery and filter
> the records in my listbox and it works fine.But after update my combobox,
> I unable to remove the filter of listbox cause there is no option to
> showing
> up all records in my combobox.How to add option all to mycombobox to
> showing up all records in my listbox.
>
> Thank's in advance.
>
>

Thank's for reply,
I found the way.


"Jeanette Cunningham" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> see if this helps http://www.mvps.org/access/forms/frm0043.htm
>
> Jeanette Cunningham
>
> "rahmad" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> >I have a combobox and a listbox.My combobox requery and filter
> > the records in my listbox and it works fine.But after update my
combobox,
> > I unable to remove the filter of listbox cause there is no option to
> > showing
> > up all records in my combobox.How to add option all to mycombobox to
> > showing up all records in my listbox.
> >
> > Thank's in advance.
> >
> >
>
>