Copying values from a previous record to a current form

  • Thread starter David T. Allison
  • Start date
D

David T. Allison

I have created a form that updates a table with bound edit box controls. The
nature of our data is that for a given field in the table there may be a
long sequence of repeat values from record-to-record, so, my form needs to
populate the current bound edit box witha "default" value derrived from the
field value from the previous record. In pseudocode I imagine something
like:

MyForm.MyEditBox = MyTable.Field1[CurrentRecord-1]

If "CurrentRecord" was a pointer to the current record in the table being
edited by the form, then the results of the expression right of the "="
should yield the previous record "Field1" value. I'm new to Access and VBA
so I'm sure the syntax is not correct- perhaps you guys can help me out.
 

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

Populate field from previous record 0
Include a field from previous record on current form 2
current record and previous record 2
How to keep users out when no current record? 1
Current Record Count, Previous Record #, Add New Record 0
Trouble associating parent form record to subform's record 1
Access Automatically Send a notification email once a record is added 0
Test whether a form is on the current record 5

Top