Duplicate a record in a table from a Form.

  • Thread starter Thread starter Jamie Perry
  • Start date Start date
J

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.
 
Jamie Perry said:
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.
Click to expand...

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?
 
-----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].
Click to expand...

[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.
 
-----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?
Click to expand...
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.
 
-----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].
Click to expand...

[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.
Click to expand...

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!
 
Back
Top