Filtering in a Split Form

[Roger Reinsch]

I have created a query that takes parameters from a form, wraps the parameters with "LIKE (*"&parameter&"*)" to search for substrings in the underlying table. The command button on the form Opens the Query which then produces the datasheet view in a NEW TAB.

I'd like to do the same sort of thing with a Split Form.

The Form would have some fields that are taken directly from the selected row at the bottom of the form. And the filter (SQL's Where) uses other text boxes on the form to select which rows should appear at the bottom of the form in the first place.

Operationally, the person doing the search would add tighter and tighter criteria (for the where clause) until the list at the bottom contained the desired record and not too many more. (There are 125K rows to be searched.) He'd then select the appropriate row which would populate many of the form fields. The final step is another button that runs an Append Query to take selected fields from the form (for the selected row) and adds them to another table.

I can't find where to put the selection criteria in the split form. It looks like this should be the perfect solution but I'm missing something. Any help would be appreciated.

Roger

 

[Galaxiom]

Build your form with subforms. Split Forms have considerable limitations that cannot be worked around when operated with VBA.