Using vba to create new record and assign to fk, good or bad?

[Kryst51]

Here's the bit (its actually from a different thread):

I should have been more specific.
You currently have
Set rsMaxRTId = Nothing
which is colloquially known as destroying (or releasing) the object variable.
Before that you would include the close method for objects which support it (we take it as read that the developers provided it for good reason ;-)
rsMaxRTId.Close

Thanks for all of your help..... It has been of great use to me.

I just had a thought, in my code I insert a date time in order to create a new record. is there a way to create a new record without putting in the stamp? Or should I put this question as a new thread?

 

[Kryst51]

Ooooh, nevermind, I just realized that I could add the "NCR" during the Insert instead of after and that would created meaningful data in the new record as opposed to something I don't really need..... and clean up the code a bit I think....

 

[LPurvis]

Cool.

Cheers.