Hey all,
     I am writing a program in Microsoft Access, eventually converting to Visual Basic and C++.  Anywho, I have a form that you input all of your subordinates on.  When you input them, I want Access to automatically assign all required training to this individual.  I have this being accomplished by a command button.  The problem is, You can keep on clicking the command button, and you end up doubling, tripling, etc... thier training requirements.  I want access to check and see if the Recordset exists and if so, do nothing, but if it does not exist, then I want it to add the required training.
  

Do you own VB/C++ now? If so, I suggest you use your learning curve time to learn one of those instead of MS Access (or Access VBA). I am usually the first proponent for MS Office apps BUT not in a case where Access is used as a FRONT-END.  


I have made several MS Access front-ends in the past (way past) and every one has been NOT AT ALL user friendly, buggy/VBA BS, and generally a waste of my time since all were eventually replaced with stronger, faster VB apps.

Just a suggestion...

Oh, and in reply to your question, I think you answered it. Check to see if the recordset exists...

____________________________
Eggheads unite! You have nothing to lose but your yolks.

Yeah, checking if the recordset exists is all fine and dandy, but how do I do that?  I am a little bit inexperianced and cannot figure it out.