Recent content by misty69

Hi again again Sorry, it was on the 'on load' on the form, for some reason I was looking on the button properties - another blond moment! Thanks for your help Misty69

Hi again, It does happen in edit mode but only when I open the form that the macro's on not on the initial opening, so It's not just lurking in the background somewhere. Thanks Misty69

Hi RoyVidar Thanks but it's not in there the total error message is: ---------------------------------------------------- WLP Tidy can't find the macro 'OK2Close = false' The macro(or it's macro group) doesn't exsist, or the macro is new but hasn't been saved. Note that when you enter the...

Hi RoyVadar Thanks for the link it works great except I've now got a problem. I originaly did something wrong and now I keep getting an error message saying "can't find the macro OK2Close = false" and I can't find where I've left the code lurking. I deleted the original mistake and have since...

Thanks everyone The database is normalised but i don't know why it didn't work in the first place. It now works with Like "*" & [Enter Word] & "*" , guess I was havin a blond moment there!! Thanks Misty69

Thanks Duane, I'll try modifying the query with 'or's it sounds plausible. Misty69

Hi Leslie Yes it does but only with the word already in the query, what i want to do is to enable the user to search for different words within the field. It might help if I explain the nature of the field that the search is based on. The field contains information on the teaching styles of all...

Hi dhookom Thanks for your reply. I've tried that one but it will only find all the text in the field. If i have for example "i teach large groups" in the field, i want to search for "large groups" with the Like "*" & [Enter Word] & "*" criteria i'd have to put in the search "i teach large...

Hi all I need to be able on a query to search within text in a field for a specific keyword. I've tried the usual like[enter word] but I can't seem to be able to limit the search to find just one word amongst many. Any ideas anyone? Thanks in advance Misty69