Setting up a Default to populate field with data from Previous Record in a Form 
Author Message
 Setting up a Default to populate field with data from Previous Record in a Form

I need to be able to fill out a name field with data from the previous
record. I am using a combo box to populate the initial record, but when I go
to the next record I need to populate the same field with the data from the
previous record.

How do I accmplish this?

Thanks{*filter*} Fr....



Sat, 14 Sep 2002 03:00:00 GMT  
 Setting up a Default to populate field with data from Previous Record in a Form
Dick,

If making the previous value the default for the next record will suffice, y
ou could set the combo's default value to its current value from its AfterUp
date event procedure.  e.g.:

Private Sub YourCombo_AfterUpdate()

    With Me.YourCombo
            .DefaultValue = .Value
    End With

End Sub

HTH,
Nicole

cppssbbsa02.microsoft.com...

Quote:
> I need to be able to fill out a name field with data from the previous
> record. I am using a combo box to populate the initial record, but when I
go
> to the next record I need to populate the same field with the data from th
e
> previous record.

> How do I accmplish this?

> Thanks{*filter*} Fr....



Sun, 15 Sep 2002 03:00:00 GMT  
 Setting up a Default to populate field with data from Previous Record in a Form
Thanks Nicole
This looks like a good solution. I will let you know how it works after I
try it on Monday.


Quote:
> I need to be able to fill out a name field with data from the previous
> record. I am using a combo box to populate the initial record, but when I
go
> to the next record I need to populate the same field with the data from
the
> previous record.

> How do I accmplish this?

> Thanks{*filter*} Fr....



Wed, 18 Sep 2002 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Populating the fields of a new record with data from previous record

2. Populate new record with default values from previous - Continuous form

3. Field default to data entered in the same field of the previous record

4. fill field in NEW record with data from different field in previous record

5. fill field in NEW record with data from different field in previous record

6. Auto populate form field from previous value in field

7. Copy previous fields from previous record during data entry

8. Form data entry: getting same value in a field as previous record

9. Automatically populating fields from previous record

10. Populate Field from Previous Record


 
Powered by phpBB® Forum Software © phpBB Group