how do you get data fields to carry over to a new record?

[wavbuser]

Is there a simple way, without setting up a module, to get certain data fields to carry over to a new record as well in MS Access 2003. I've tried alot of modifications to the "default value" but none of them seem to work.

If anyone can help me out it would be greatly appreciated.

[ADezii]

Is there a simple way, without setting up a module, to get certain data fields to carry over to a new record as well in MS Access 2003. I've tried alot of modifications to the "default value" but none of them seem to work.

If anyone can help me out it would be greatly appreciated.

1. Do you want ALL Fields carried over to the New Record or selective ones?
2. Do you want these values automatically transferred over to the New Record, or when you enter these Fields?
3. Once data is entered into a Field, does it become the new default Value for that Field?

[Rabbit]

Is there a simple way, without setting up a module, to get certain data fields to carry over to a new record as well in MS Access 2003. I've tried alot of modifications to the "default value" but none of them seem to work.

If anyone can help me out it would be greatly appreciated.

Does this table have a unique field that increments for each record added?
If it does then you can use a DMax embedded in a DLookup.

[wavbuser]

1. Do you want ALL Fields carried over to the New Record or selective ones?
2. Do you want these values automatically transferred over to the New Record, or when you enter these Fields?
3. Once data is entered into a Field, does it become the new default Value for that Field?

Sorry for being unclear before:

I only need selective fields to be carried over, not all.

I'm actually using a form so, when the user decides to insert a new record, I want certain fields from the previous record to carry over.

Yes, once the values in the selective fields are modified on the form, i want those value to become the new default values.

[wavbuser]

Does this table have a unique field that increments for each record added?
If it does then you can use a DMax embedded in a DLookup.

No, unfortunately the records do not have any fields like that.

[Rabbit]

You'll probably have to add one then, unless ADezii has another idea.

[wavbuser]

Ok i've found that solution for those of you with a similar problem, google "previous record" instead of "carry over", it works alot better, anyways, i found the solution in another forum there.

http://www.thescripts. com/forum/thread203454.ht ml

incase it doesnt work here is the main thing you need:

It *is* a field property.

In the AfterUpdate event of the control (let's say it is called
theValue), put

theValue.defaul tvalue = theValue.value

If theValue is text, do this:

theValue.defaul tvalue = "'" & theValue.value & "'"

http://www.thescripts. com/forum/thread203454.ht ml

[Rabbit]

Ok i've found that solution for those of you with a similar problem, google "previous record" instead of "carry over", it works alot better, anyways, i found the solution in another forum there.

http://www.thescripts. com/forum/thread203454.ht ml

incase it doesnt work here is the main thing you need:



http://www.thescripts. com/forum/thread203454.ht ml

This solution uses a code module which is what you wanted to avoid in the first place.

[ADezii]

Sorry for being unclear before:

I only need selective fields to be carried over, not all.

I'm actually using a form so, when the user decides to insert a new record, I want certain fields from the previous record to carry over.

Yes, once the values in the selective fields are modified on the form, i want those value to become the new default values.

Only a couple of lines of Code will do the trick for you.

1. For each Control that you wish to carry over its value, set the Control's Tag Property to Carry.
2. Place this code in the AfterUpdate() Event of the Form.
3. For each Control that you elected to carry over, set its Tag Property to Carry, its Default Value will be reset and will subsequently appear in New Record mode.
4. Let me know how you make out with this.

Dim ctl As Control
 
For Each ctl In Me.Controls
  If ctl.Tag = "Carry" Then
    ctl.DefaultValue = "'" & ctl.Value & "'"
  End If
Next

[ADezii]

Ok i've found that solution for those of you with a similar problem, google "previous record" instead of "carry over", it works alot better, anyways, i found the solution in another forum there.

http://www.thescripts.com/forum/thread203454.html

incase it doesnt work here is the main thing you need:



http://www.thescripts.com/forum/thread203454.html

Be advised that this approach does not take into consideration the carrying over of values for 'selective' Controls, see my response in Message #9.