Search results

No it was resolved it was only happening when it was a small case "i" and not when its a capital "I" so just forced it to have capitals used and its now working fine I have no idea why a small "i" should not work

Oh My Gosh Page 2 I missed that completely and thank you very much that resolved my issue many thanks

thanks for the reply its not quite what Im after the search does not either close or open a form it simply shows the correct record on the current form even if there is no record with a particular letter it still works and shows best match so far I have tried it on various pc and laptops...

I get a run time error 2110 dialog box "Mobile cant move the focus to the control User name" the Mobile is name of database and the control is on the form and it does actually show the next record that starts with "I" but its just the error message thati then have to click "end"

help please I have a simple bit of code that searches for a [User Name] field the basic idea is I place a field called "search" on a form and set its on change to Private Sub Search_Change() Search.SetFocus strtarget = Search.Text If strtarget < "a" Then strtarget = "a" [User...

that was excelent worked a treat and yes i would be interested in how add to someones else calander I do however email reports etc to individuals so no reason why a email with info could not be sent to another person I set up a variable dim mailstr as string and add text to that for the...