Entering Data and then having another linked data show up.

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!
 
S

Steve Schapel

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
 
J

John Vinson

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!

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top