Help to add set of records only once!

[Debased]

Kind of a lame title for the thread but I'm feeling kind of lame.....

I have a form with subforms. One of the subforms gets populated with a set of records that are questions for a survey. I have the main form's date field's AfterUpdate event coded to add the records but if you modify the date field, another complete set of records is added. I know I could have the user manually add the records with a command button and then disable it but was trying to handle it a different way.

Any suggestions?

 

[Debased]

Thanks Pat! I put the code in the AfterUpdate Event and it seems to be working fine. Once again, I learn an important lesson from you. Thanks

 

[Crilen007]

Pat is a smart, helpful woman =)

We all appreciate his presence on this forum =) (atleast, I do)

He is a great help.

 

[Crilen007]

He should appreciate you =)

All husbands should apperciate their wives.

(sorry about the guy comment, i thought you were male.. ill edit that)