carry over

[icemonster]

ok, i found a code from allenbrowne from carrying over the last record to the new one, i want to know if someone if familiar with that but also carry over the entire subform that has more than 1 record but shares a FK with the main form?

 

[GinaWhipp]

Here you go...

Duplicate the record in form and subform

http://www.allenbrowne.com/ser-57.html

 

[icemonster]

well, it's really not duplicate but rather just have the fields from the last record be the default value on the new one, but am gonna try it out thanks!!

 

[GinaWhipp]

Oh, then you can use...

Private Sub YouField_AfterUpdate()
Me.YourField.DefaultValue = """" & Me.YourField.Value & """"
End Sub