Search for Record, create new if not existant

[asmith]

Hey everyone,

I'm trying to create a macro to execute after a form text box updates. I'm aware of how to attached the macro to the "After Update" event but i'm having trouble with the macro itself.

What i'm looking to do is take the value of cell that has just been updated and use that for the search criteria to look at the history table and search for that value in a specific column. If the value exsists, do nothing, if it doesn't exsist create a new record and populate the value using the search criteria.

The only start i have is i believe i've found the code to create a new record which i think is : "DoCmd.GoToRecord , , acNewRec"

Any help or references would be greatly appreciated.

Thanks!
Andrew

[pbaldy]

I don't use macros, but I assume you can put a DCount() in the Conditions box and only perform the action if the count = 0.

[asmith]

Thanks for the tip pbaldy

I was able to encorporate the DCount feature in some VBA and it worked perfectly.

[pbaldy]

Excellent, glad it worked for you. I think you'll be happier with VBA than macros in the long run anyway (though they have improved them in 2010).