Copy Subform rs to New Record

[pbaldy]

Happy to help!

 

[LBinGA]

So, another question related to this, if I may.....

Is there a way, through this code, to retain the default values in the new record when I "Copy Into New"? The code is creating a new record but the default values do not carry over causing issues with some calculations (anything times 0 is still 0).

I could insert each field that requires a default value into the code but I thought there may be a way to programmatically do it other than that. I have 50 fields that carry a default value of 1.000.

Thanks in advance!

LBinGA

 

[pbaldy]

Are they default values at the table level, or just on the form? I would expect table level defaults to work.

 

[LBinGA]

Ok. Duh. :banghead:
I better go get some more coffee......

Thank you!!!!

LB

 

[pbaldy]

No problemo!