Duplicate a record in a table from a Form.

[Jamie Perry]

I am trying to duplicate a record within the same table.
Basically I have fields that will always be the same.
Field 2 and 3 will always equal field 1. How can I set
it up so that a user only types the number in field 1 on
the form but the data is stored in field 1, 2, and 3 in
the table.

 

[Rick Brandt]

I am trying to duplicate a record within the same table.
Basically I have fields that will always be the same.
Field 2 and 3 will always equal field 1. How can I set
it up so that a user only types the number in field 1 on
the form but the data is stored in field 1, 2, and 3 in
the table.

Someone has to ask so it might as well be me.

If these three fields are always the same, why do two of them even exist?

 

[Marty Suckstorff]

-----Original Message-----
I am trying to duplicate a record within the same table.
Basically I have fields that will always be the same.
Field 2 and 3 will always equal field 1. How can I set
it up so that a user only types the number in field 1 on
the form but the data is stored in field 1, 2, and 3 in
the table.
.
You could use the On Exit Event Procedure of [Field1].

[Field2] = [Field10
[Field3] = [Field1]

Or, in the control source property box for [Field2] and
[Field3] you could type: =([Field1])

Are you massaging these three fields later in your
application to include different info? If not, you don't
need all three.

 

[Jamie Perry]

-----Original Message-----


Someone has to ask so it might as well be me.

If these three fields are always the same, why do two of them even exist?

Order files that we have to send always have a BTN and WTN
which are telephone numbers. The file layout that we are
required to use ask for both. The first WTN will always
match the BTN.

 

[Jamie Perry]

-----Original Message-----

-----Original Message-----
I am trying to duplicate a record within the same table.
Basically I have fields that will always be the same.
Field 2 and 3 will always equal field 1. How can I set
it up so that a user only types the number in field 1 on
the form but the data is stored in field 1, 2, and 3 in
the table.
.
You could use the On Exit Event Procedure of [Field1].

[Field2] = [Field10
[Field3] = [Field1]

Or, in the control source property box for [Field2] and
[Field3] you could type: =([Field1])

Are you massaging these three fields later in your
application to include different info? If not, you don't
need all three.

Thank you very much, I will try these options. I tried
something similar and they wouldn't work, but I'm not sure
I had the brackets and Parenthesis. Again Thanks!