Entering Data and then having another linked data show up.

  • Thread starter Thread starter Jennifer Van Pelt
  • Start date Start date
J

Jennifer Van Pelt

I am creating a form. What I need help doing is setting
up the following. First, I have a list box with about 12-
15 options to choose. Each of these options have two
numbers that go with it. When one of the options is
chosen I want those to numbers to automatically pop up to
correspond with the chosen option. How do I do this?
Pleas help!
 
Jennifer,

Are the 2 numbers which "go with" the items shown in the listbox,
included in a table? If so, the easiest way to achieve your purpose
is to include this table in the query that the form is based on, and
include the number fields on the design of your form. Then as soon as
you make your selection in the listbox, the corresponding numbers will
be shown. Another option is to make the rowsource of the listbox
multi-column, to include the associated numbers (they can be hidden if
you want), and then use unbound textboxes on the form with their
controlsource set to (for example)...
=[NameOfListbox].[Column](1)

- Steve Schapel, Microsoft Access MVP
 
I am creating a form. What I need help doing is setting
up the following. First, I have a list box with about 12-
15 options to choose. Each of these options have two
numbers that go with it. When one of the options is
chosen I want those to numbers to automatically pop up to
correspond with the chosen option. How do I do this?
Pleas help!
Click to expand...

"Pop up" - where? In textboxes? in a MessageBox? do you want to store
them in a table, or just see them?
 
Back
Top