how to default values from last record

  • Thread starter Thread starter please help!
  • Start date Start date
P

please help!

Hi. I have a form with three list boxes, and a value
selection is made in each list box. Then the record is
saved and a new blank record is presented.

However, I would like to default into the new record the
values from the prior record just entered. In fact, I
would ideally like to default only the value from the
first list box (as this first value does not change
frequently, while the other two values do change every
record).

Can anyone tell me if/how this might be possible? Many
thanks in advance for any tips/tricks/suggestions.
 
thanks! how do I enter this code in the default value
field of the control when it brings up the expression
builder? or does this code belong in the command button?
 
1. Set the AfterUpdate property of the text box to:
[Event Procedure]

2. Click the Build button (...) beside this.
Access opens the code window.

3. Paste the code in there, between the "Private Sub ..." and "End Sub".
 
Back
Top