Search results

Through much trial and error I finally got this thing to work. The Access Help example for FindRecord shows the search argument enclosed in quotes, but this did not work in my case. In desparation, I tried enclosing it in parentheses and that worked like a charm. Thanks to all who pondered this...

Thanks for the tip, but pre-setting the focus to the problem control didn't help.

In Access 2000, I use the AfterUpdate event in the first field of a customer input form to call a function (not an Event Procedure) which checks if a new customer has the same ID as an existing customer (by using DCount > 0), to prevent typing more data. If so, I display a warning message, save...