G
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 stayed 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 entry
window. 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 operation for my business. I am programming edi files and I
wanted to use this method, but it’s obvious I am doing something wrong.
Again, I would be very glad to email the file. Here are the properties for
my combo box:
Row Source Type:Table/Query
Row Source: SELECT Drivers.Row, Drivers.DriverName, Drivers.DriverValue FROM
Drivers;
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 stayed 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 entry
window. 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 operation for my business. I am programming edi files and I
wanted to use this method, but it’s obvious I am doing something wrong.
Again, I would be very glad to email the file. Here are the properties for
my combo box:
Row Source Type:Table/Query
Row Source: SELECT Drivers.Row, Drivers.DriverName, Drivers.DriverValue FROM
Drivers;