Originally Posted by
June7
You changed your field names to match the code???? That was a big mistake. Did you also change your table names to match the code?
> Finding the names in code is really simple. You must have found them to even know what to change yours to.
I could not (initially) find any reference to FIRST or LAST in the code. I have since found another window of code that does have reference to FIRST and LAST. I can make that a bit better now.
> If you are using the code in the article, what happens - error message, wrong results, nothing?
> If the form is bound to table with the data, then it should display data.
The search function returns the answer I expect. What I would like to do is have the rest of the fields be populated with the data belonging to the selected record. (I simply pasted my database in place of the original table - and that generated the correct additional fields for my more extensive data.)
> Hope fields are not named FIRST and LAST - these are reserved words. Also, advise no spaces or punctuation/special characters (underscore only exception).
> Better would be First_Name or FirstName.