How do I dafault a value from another field?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table with 5 columns

And a form linked to this table with the same 5 fields in it, these can be
directly typed into via the form.

What I want to happen is in the form, when I type a value into field 4 field
5 defaults to this vale and adds it to the table as if I had typed it in.

Does anynody know of a way that I can do this other than having its control
source set to field 4?
 
I have a table with 5 columns

And a form linked to this table with the same 5 fields in it, these can be
directly typed into via the form.

What I want to happen is in the form, when I type a value into field 4 field
5 defaults to this vale and adds it to the table as if I had typed it in.

Does anynody know of a way that I can do this other than having its control
source set to field 4?
Click to expand...

If the value of Field5 is the same as Field4, why do you need Field5?
 
Fredg,

I only want field 5 to default to field 4 automatically, but people may need
to overtype the value in field 5.
 
Fredg,

I only want field 5 to default to field 4 automatically, but people may need
to overtype the value in field 5.
Click to expand...

Code the AfterUpdate event of Field4:

Me![Field5] = Me![Field4]
 
Back
Top