autofill text field on selection of combobox

[firthk]

I have just started using Access & all was going well until ....

I have 2 tables - one (HorseList)contains a list of horses field & a points field - the other (Selections)contains a name field & ten combo boxes populated from the the horses field in the other table. I have created a form using fields from both tables. The idea being that when I select a horse from the combobox list the points field next to it will populate with the appropriate number of points taken from the first table. This works ok for the first combo box (Horse1) but when I select another horse in the second combo box (Horse2) the points field next to it still contains the points associated with Horse1 ? in fact everytime I select a horse in the Horse1 all ten points fields will change to the number of points for that horse !! I hope I have explained this clearly enough. It seems to me that there should be some link between the combo boxes and the points field?

Heres Hoping...

Ps I have attached the DB info.

 

[indesisiv]

Have you tried searching this forum for "cascading combo boxes" or Autopoulate"

May help identify some of your problems.

 

[firthk]

thanks - I've just read all the info on CCB's & autopopulate & am still none the wiser - I'm off to buy a huge book !

 

[Rich]

ReQuery the second combo on the After Update event of the first

 

[firthk]

many thanks - I think I see where you're coming from ...
will keep in touch