Have one fill to auto fill aother

  • Thread starter Thread starter Kaylen
  • Start date Start date
K

Kaylen

My question is simple. I would like to have field 27 = field 25.
So when someone enters the data for field 25, the same data auto populated
in field 27. Any help is appreciated!
 
Kaylen,

In the CotrolSource for Field 27 type...

=[field 25]

....assuming of that you are talking about a form in Microsoft Access or did
you mean to post this question in the Excel newsgroup?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
There are quite a few ways, I would go with an event proceedure (either on
change or after update) to fill in.

Example:

Private Sub Field25_AfterUpdate()

Me.Field27 = Me.Field25

End Sub

Hope that helps
 
Kaylen

Why? If you already have a value stored in [field25], why do you believe
you need to (redundantly) store the same value in [field27]?

More info, please...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
Kaylen

I strictly interpreted your question based on the terms you used. In
Access, a "field" exists only in a table, hence my comments about storing
data.

If you are referring to having a form display data, those are called
"controls" in Access. But my question remains... if you already have it
showing in one control, what business need are you trying to satisfy by
showing it in another?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
Back
Top