List Box issue

[Savannah]

Can anyone assist, I have created a database with two tables and a form to record individual horses and the shows that they attend, the shows being a sub-form. The idea is that I will be able to run queries etc on 'Sections' within date ranges of shows to give me totals point scores and overall winners each year. My form has buttons to create new records and select already created records (first, last etc). I have created 2 'list boxes', one for a member being active or inactive and one for 'Sections' (of which there is 3 options eg: Welsh A, Welsh B and Welsh C) which I typed in the values, I want to be able to select one of the three for each horse entered on a new record. I've entered 5 horses to test it out. Now when I select a 'Section' on any record, it changes the value on every record to the same selection. I can't select different values for each record. Is this what it is meant to do? It also says unbound in design view (is this because I didn't select the values from a table or query?) Please note I'm very new at Access and am using wizards etc so may need you to point me in the right direction if you start talking coding. Thank you.

Here is an example:


If you select active for one member it makes every member on every record active as well.


Is there a way to fix this?

[pbaldy]

Yes, the control being unbound is the issue. If you want the value saved for each record, the control must be bound to a field in the underlying table.

[Savannah]

Thank you, I tried creating list box using the wizard and the table I created for Sections. I have added Name of Horse in each table which is the join in the relationships (though not the primary key). Now it gives me nothing drop down menu and nothing to select. I'm still researching an attempting to correct it though.

[Savannah]

Fabulous, I fixed it Thank you. I had my table set up incorrectly but it's now working and each record can select a different value. Regards, Savannah.

[pbaldy]

Happy to help and welcome to the site by the way!