Combo box lookup table problem

[Guest]

Hey - I have not learned the vba method of using access - do it all the easy
way thru the wizards and tables. So I don't know how to ask my question.
But, here it is. I keep the stats for a NASCAR fantasy league and I wrote a
little program to help me with it. I created a combo box on the team entry
form using a lookup table with the wizard. I wanted to select a driver's
name from a table and fill in a field for the driver's value on the form so I
could make sure they stated within the dollar limit. The bound field - the
dollar value -is filled in correctly. But if a team chooses a driver worth
325,000 such as Robby Gordon, the selection is made in the combo box. But it
immediately turns into Ward Burton 325,000 because he is first in the table
with the same value. It is confusing to fill in this form. I had to add a
separate selection for the driver name. So I have to select the driver
twice. I cannot figure out how to fix this. My email address is
(e-mail address removed) if you want a copy of the file -it's small - to
see what I mean. Someone please help me. I have to do a similar, more
complex op-eration for my business. I am programming edi files.

 

[Jason Lopez]

What kind of query are you using on the combo box? That can play a part in
it. You will also need to make sure to requery your combo box (or the test
box) so that the proper value is placed in there.

Look at your field properties and let us know what you see as far as the Row
Source. That will help us help you in greater detail.

Jason Lopez

 

[Guest]

Thanks. Here is the info:

Row Source: SELECT Drivers.Row, Drivers.DriverName, Drivers.DriverValue FROM
Drivers;
Row Source Type:Table/Query