How do I keep the same data from one record to the next record, i.

G

Guest

I am working on an Access 2000 form (with record selector capability) that
has a calculated text box. When I click the record selector for the next
record, I want the calculated text on this new record to conatain the data
from the previous record.

How can I carry over the data from one record to the next?
 
G

Guest

Marion Stokes said:
I am working on an Access 2000 form (with record selector capability) that
has a calculated text box. When I click the record selector for the next
record, I want the calculated text on this new record to conatain the data
from the previous record.

How can I carry over the data from one record to the next?
Click to expand...

try:
Me.YourControlName.DefaultValue = Me.YourControlName

in the AfterUpdate event of the Control.

-Amit
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Custom Record Selector Controls that don't work like the built-inones 1
Need combo box to refresh when moving to new record 2017 1
selecting a record from continuous form 3
Using check box to make record active 3
Using one command button to open one of two forms 3
Stop Record Deletion 2
How do i... 10
Delete record from a form 2

Top