L
Lucky Afternoon
I have a fairly good understanding of Access and have built quite a few data
bases.
I'd like to know how to make text automatically populate a field when using
the option box. (of a combo box) For example, if I have an option or combo
box with 3 cities names listed, how can I make text populate another field.
I can assign the option or combo box to a field but the "valueoption" number
populates the field. (example a 1, 2, or 3) In other words, how do I assign
a paragraph of text to a valueoption? I hope I'm asking this in a way that
it is understandable. If not, I can send a small sample database to
furthur illustrate my question. I have tried using the lookup option with
another table but I don't seem to have the settings correct.
Thanks in advance to anyone who is willing to help me with this.
Dave
bases.
I'd like to know how to make text automatically populate a field when using
the option box. (of a combo box) For example, if I have an option or combo
box with 3 cities names listed, how can I make text populate another field.
I can assign the option or combo box to a field but the "valueoption" number
populates the field. (example a 1, 2, or 3) In other words, how do I assign
a paragraph of text to a valueoption? I hope I'm asking this in a way that
it is understandable. If not, I can send a small sample database to
furthur illustrate my question. I have tried using the lookup option with
another table but I don't seem to have the settings correct.
Thanks in advance to anyone who is willing to help me with this.
Dave