Solved Filter the form based on value selected from Combo Box (1 Viewer)

[shery1995]

Hi All

I am trying to display/show records on my continuous form based on the value selected from combo box. However, when I run the form and click on combo box first it asks me for parameter value and then shows that value in combo box instead of showing Customer Type. When I select each value one by one from combo box it shows the correspondence record but does not show the string value in combo box. I have attached the file and would be much obliged if some one can help. Please note that I don't want to use subform.

Your kind advice and suggestions much appreciated.
Kind Regards

 

[MajP]

Look at the rowsource for the combo. You have the Type field listed twice causing the problem.

 

[theDBguy]

Hi. Try it now...

I just removed Expr1 from your combo's Row Source.

Edit: Oops, too slow... Sorry.

 

[shery1995]

Thank you very much that is exactly what I want. You are great

 

[shery1995]

Look at the rowsource for the combo. You have the Type field listed twice causing the problem.

Thank you very much for your suggestion.

 

[theDBguy]

Thank you very much that is exactly what I want. You are great

Hi. You're welcome. @MajP and I were happy to assist. Good luck with your project.