Search results

Legend! Cheers

Hello, I understand that when using the "Like" command in a query - you should make use of wildcards to obtain the required data, but what happens if the required data is user inputted? ie I currently use in the criteria box.... forms!frmselectclient!txtsearch.text but I effectively want...

Can I use the ADOrs.Open "QueryName" to open a query? As the record I need to find, will be obtained by a query.. Hope im making sense!

Very Good cheers, i'll have a play with this shortly. I knew it would be fairly simple, just needed a push in the right direction. Regards

Hello, I am currently *trying* to create a pretty simple DB which will allow the company which I work for to keep a table containing a list of clients, a table containing a list of services, and to be able to link between the two. I've setup 3 tables, a Client table, Service table and a Link...