This is my first post on here so please humour me.
I have built a database but it is quite basic. The thing is that the table I have has 11800 records called tblToolLists! The fields are ID (Primary Key), Description1, Description2, Description3, Description4, Description5
I need to be able to create a form with an unbound box and an embedded subform/subreport so when a keywork is typed into the unbound box and then a control button pressed Descriptions 1-5 will be searched and results will be displayed on a subform or subreport... the more keywords the more refined the search..
It feels like this is gonna be a biggy and I have no clue where to start!!!