Combo Box Question

[Jens]

I created a Database and there is a primary key field
that is called project code. There are about 100 fields
that are associated with this key. When I created a
form, I am allowing the user to choose what project
number they want through a combo box or they could just
add a new one. When I add records, everything is ok, the
problem I am having is when I try to navigate through the
records, only the value in the combo box will change.
How do I get it to change everything associated with that
record? Ex: the default project is 1, I scroll down and
choose project five (it will have different info),
nothing changes except for the project number (5).
Please Help.

Thanks,
Jens

 

[Larry Linson]

One of the options of the Combo Box Wizard is to create a Combo Box to
control the contents of the Form. It'll be much easier to either re-create
your Combo with the Wizard, or create another, examine it, and modify your
code to match than to describe it here.

But, if nothing is happening, then you are not using an unbound combo with
the proper code in the After Update event. If you use a bound combo, you are
making "unexpected modifications" to data in your records, probably with
consequences that are not good at all.

Larry Linson
Microsoft Access MVP