Display value from previous record.

[Tony Schoeffler]

I have a data entry form used for adding records tied to a particular
checklist number. I currently have to enter the checklist number on
each new data entry form. It would be desirable to have the new data
entry form display the checklist number from the previous record. Is
there a reasonable way to do this? Thanks in advance for any help.

Tony

[Jim Allensworth]

On Thu, 29 Apr 2004 22:23:27 GMT, Hu***************@lerc.nasa.gov
(Tony Schoeffler) wrote:

I have a data entry form used for adding records tied to a particular
checklist number. I currently have to enter the checklist number on
each new data entry form. It would be desirable to have the new data
entry form display the checklist number from the previous record. Is
there a reasonable way to do this? Thanks in advance for any help.

Tony

Use the control's After Update event to set the control's Default
Value to the value just entered.

- Jim

[Bob Quintal]

Hu***************@lerc.nasa.gov (Tony Schoeffler) wrote in
news:c6**********@sulawesi-fi.lerc.nasa.gov:

I have a data entry form used for adding records tied to a
particular checklist number. I currently have to enter the
checklist number on each new data entry form. It would be
desirable to have the new data entry form display the
checklist number from the previous record. Is there a
reasonable way to do this? Thanks in advance for any help.

Tony
Very. There are several ways to do it, depending on your particular
needs, but one I like to use is to set a command in the AfterUpdate
event of the Checklist Number control.

That command sets the .defaultvalue for the cheklist_number to the
value just entered.
So (air code, not tested)
private sub Checklist_AfterUpdate
me.checklist.defaultvalue = me.checklist.value
End sub.

Note that if you close the form, the default value will be blank
again.

But you might also consider having a masterform for the checklist
info, and a subform for the checklist items.

Bob Quintal