Form combo box (1 Viewer)

I am trying to use a combo box to completely filter my form. Right now I am using a filter on a txt box related to my primary key to filter the form and it works it’s just not that user friendly.

My main form is called fund list and my primary key that relates to all my tables and the one I am using to look up and want drop down to have on it is called Legal entity.

Hopefully this makes sense.

Hi. Not sure what the problem is except maybe the combo is bound to an ID field instead of a regular text field like the textbox probably is.