Multiple records with different values

[HVACMAN24]

I'm making a database for a judging event and I've made a form that pulls all the contestants #'s from the table then has a bunch of combo boxes for each element of the event for the scoring. My problem is when I change the combo box for one element it changes it for all the contestants. How can I automatically populate the contestant #'s and change the scoring for each one separately?

Thanks

 

[DCrake]

Sounds like to me you have a subform that is set as a continious form. Is this correct?

 

[HVACMAN24]

no, I dont have a subform. I attached a pic of what my form looks like maybe thatll help.

 

[missinglinq]

If changing the selection for one record's combobox changes the selection for the combobox on all records, the combobox is unbound. This is the normal behavior for any unbound control.

To have each combobox retain a selection for a given record you have to bind it to a field in the underlying table, using its Control Source.

Linq ;0)>

 

[DCrake]

Ok it is not a subform but it has been set to be continious as my earlier comments suggested. And as ML also indicated unbound controls act differently to bound controls.

 

[HVACMAN24]

Thanks guys, I thought it might be something related to bound/unbound but wasnt sure. I fixed it so everything is bound and its all working like I want. But now I'm trying to add a reset button to reset all the records to a default value. Is there something that selects all the records on a continous form to reset everything with one click instead of having to select each record individually?

 

[DCrake]

What you need to do is to run an update query on your recordsource and requery the recrodsource.

 

[HVACMAN24]

Whats the proper way to requery the recordsource? Everything I've tried has not worked.

 

[DCrake]

If you have done the update query all you need to do is reapply the recordsource to the form. Or Forms.Requery