Searchable text box in a split form that shows the search results in the lower part of the form

[rebfein]

Hi all,



First, my thanks to all who respond to my questions, you've been very kind and I appreciate it immensely.

Now for today's issue. The engineers would like a form created so they can find parts they need by type. I created a split form where the part information is in the first part of the form and the entire parts list appears in Datasheet style in the bottom part of the form. See attached picture.



I want the form to allow the user to select an option from a list of categories (drop down box), then show a list of the resulting items for that category in the lower part of the screen. I can't get the search box to search as text (Under the Format Tab of the Properties sheet, the Decimal Places Field is set on Auto and there's an @ in the Format field), and it is set to one selection that I can't type over in Form view. Every time I try to set up the Control Source in the Data Tab, the Expression Builder screen comes up.



The search results include ALL the categories, not a list of parts matching that one category, AND, in a different order than in the initial query this form is based on. HELP!

[June7]

Should not be anything in the ControlSource of combobox. Controls used to input search criteria must be UNBOUND.

Need to set the RowSource property.

Review:

http://www.datapigtechnologies.com/f...tomfilter.html
http://www.allenbrowne.com/ser-62.html