Recent content by Bleem

Thanks - I did try that but it didn't work out. When I tried to use the query as the form source, it popped up with boxes asking me to enter a value for the search parameters, qtitle1, qauthor1 etc I also took a look at opening the form after the search button was clicked but had no joy with...

Database all up and running with search working no problem - my next step is to have the search results output to a form of some sort. How do I pass query results to a textbox on a form? I'm assuming if there are multiple results found i'll need to add a 'next record' and 'previous record'...

Fantastic - thank you very much indeed :smashin:

The search string is being plucked from a textbox in a form though so I'm not sure how that would be done. The query criteria I have set is Like [forms]![searchform].[qtitle1] & "*" where qtitle1 is the text input in the 'search' field.

Ok, I think I know what the problem is - fixing it is another matter though. When I click the search button, it's looking for records "starting with" the search term. If I search for example for "Psychology" it only returns those records that start with the word and not those that contain it...

Thanks Statsman - I've imported all my data and looking good so far. I've been following the tutorial here to help create a search function on a form but having problems with it. I can complete all the steps in the flash video without issue, but when it comes to doing a search it just returns...

Hi all, First post so please be gentle :o I'm looking for a bit of advice and direction creating my first functional access database. I'm an IT professional so know my way around access pretty well in terms of being an end-user - but I'm a bit stumped when it comes to building forms and such...