Adding Field Data In A New Subform row

Bob Barnes · Nov 20, 2007

I'm using this in a Subform to add the Date in each Record

Private Sub Form_BeforeInsert(Cancel As Integer)
BDate = Forms!frmMain!TheDate
End Sub

If my just entered Record has...11/18/07....1..2...Blue,
....when I enter a new Record in the Subform, how can I
get the...1...2...Blue (above)to populate in the new Record?

TIA - Bob

Tom van Stiphout · Nov 20, 2007

On Mon, 19 Nov 2007 17:58:00 -0800, Bob Barnes

If I understand you correctly, this article about setting the
DefaultValue of a control based on the current value might apply:
http://www.mvps.org/access/forms/frm0012.htm

-Tom.

Bob Barnes · Nov 20, 2007

That works. Beautiful...thank you - Bob

Tom van Stiphout said:
On Mon, 19 Nov 2007 17:58:00 -0800, Bob Barnes

If I understand you correctly, this article about setting the
DefaultValue of a control based on the current value might apply:
http://www.mvps.org/access/forms/frm0012.htm

-Tom.