By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,638 Members | 2,204 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,638 IT Pros & Developers. It's quick & easy.

Display value from previous record.

P: n/a
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

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Nov 12 '05 #2

P: n/a
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


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.