filter list box by radio button

[mohamedmatter]

hello members
i attach simple patient DB
in search form.i set search text box in search form and i set radio button .the default radio in all
i want when i select radio blood type between A or B or AB or O filter list box by blood type to search it
i want help
thanks

 

[theDBguy]

Hi. Have you tried either requerying the listbox or modifying its RowSource property?

 

[mohamedmatter]

Hi. Have you tried either requerying the listbox or modifying its RowSource property?

I don't know
I want help

 

[theDBguy]

I don't know
I want help

Hi. I'll see if I can download your db later on.

 

[mohamedmatter]

Hi. I'll see if I can download your db later on.

thanks
I Wait you

 

[theDBguy]

thanks
I Wait you

Okay, please give this one a try and let us know if this is what you want.

 

[mohamedmatter]

Okay, please give this one a try and let us know if this is what you want.

thanks
i found problem
when i select blood type B for example it filter list box
but when search any name when i write it remove filter
i want to search in select category
thanks for help

 

[theDBguy]

thanks
i found problem
when i select blood type B for example it filter list box
but when search any name when i write it remove filter
i want to search in select category
thanks for help

Oh, I didn't realize you had a search box. I was just concentrating on figuring out your original question. Let me take a look again.

 

[theDBguy]

thanks
i found problem
when i select blood type B for example it filter list box
but when search any name when i write it remove filter
i want to search in select category
thanks for help

Okay, see if this is what you meant. I hope I understood your requirements correctly.

 

[mohamedmatter]

Okay, see if this is what you meant. I hope I understood your requirements correctly.

thanks for your efforts

 

[theDBguy]

thanks for your efforts

Hi. You're welcome. I hope it helped. Cheers!