Finding Duplicates

[prkundan]

When a number is typed on a form I want to immediately check whether it already exists in the database. Can this be done through code?


Also when my code is lang I want to display "Please wait..." and when my code finishes it should vanish. How to do it?

 

[prkundan]

That is because you never stated that you were running this code in a subform against a parents form control.?

I am extremely sorry!
I would like to know if there is any command like RunCommand acCmdSaveRecord to go to a new record on the parent form.
I would be clicking on a field in the sub form.

 

[welshgasman]

A new record would be [FONT=&quot]DoCmd.GoToRecord , , acNewRec
Not sure how you would execute it from a subform though.

Perhaps put it in event in the parent form and call from the subform.?[/FONT]

 

[prkundan]

Thanks for the advice. GOD BLESS YOU!!!