Working with continuous form....

[ZRexRider]

I need some suggestions....

I have a sub-form that acts as a continuos form. I want to allow the
user to optionally click a button at the end of the "NEW" row that will
copy some of the previous rows contents.

How do you address the previous row of a continuous form?

Thanks

[David Lloyd]

Re: Working with continuous form....

One way to address the previous row is through the Recordset property of the
subform. The following KB article shows how to copy data from the previous
record to the current record of a form. Obviously, you will have to adjust
this to your specific needs.

http://support.microsoft.com/default.aspx?scid=kb;en-us;210236

--
David Lloyd
MCSD .NET

http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


"ZRexRider" <jerryg@ptd.net > wrote in message
news:1132688089 .039495.310700@ g47g2000cwa.goo glegroups.com.. .
I need some suggestions....

I have a sub-form that acts as a continuos form. I want to allow the
user to optionally click a button at the end of the "NEW" row that will
copy some of the previous rows contents.

How do you address the previous row of a continuous form?

Thanks

[ZRexRider]

Re: Working with continuous form....

Excellent Lloyd - great tip - works perfectly!

Thank You