Carry forward last record in subform

[Carlee]

Hi everyone,

I have a form that contains Claim information and Claim Details (subform).
A claim can have many claim details listed against it.

Most of the time the claim details have the same location, however, 1 out of
10 will have a different location.

To add claim details, the user is required to click an Add button,upon which
they will be taken to a add records screen.

Question: How can i go to the master claim form, loop through the claim
details and have the location details of the last record entered used as the
default location values of the new record being created.

Many thanks for your help in advance

 

[Jeff Boyce]

Carlee

You could look into having the form (subform) save the value in that field
into the Default property after updating the record (a bit of work, but
doable).

Or you could have the users use the Ctrl-' (control + single quote) key
combination when they get to the repeated field to "copy down" the value in
the previous record. Note that this should work for ANY field, not just the
one you mentioned.

Regards

Jeff Boyce
Microsoft Office/Access MVP