When a user enters the value of an existing primary key into a form, I would like to display the existing record in a form, or allow the user to continue if the record key doesn't already exist.
I've tried some code using FindRecord but may not have the syntax correct. I've placed the recordkey into vRecKey and then used FindRecord = vRecKey but it doesn't seem to work, and the FindRecord documentation is somewhat incomplete.
Does anyone have a snippet of code that will do this? I'm sure it's a pretty common use.
Also, where should the code be placed? On Exit, On Lost Focus, or where?
Thanks,
Shin
I've tried some code using FindRecord but may not have the syntax correct. I've placed the recordkey into vRecKey and then used FindRecord = vRecKey but it doesn't seem to work, and the FindRecord documentation is somewhat incomplete.
Does anyone have a snippet of code that will do this? I'm sure it's a pretty common use.
Also, where should the code be placed? On Exit, On Lost Focus, or where?
Thanks,
Shin