Form with Subform and Combo Box

[jlgray0127]

Since I'm having so many issues getting the combo box to work, I added an event to the record, so when the user double clicks any of the fields, which are read only, it opens a pop up form with the 3 records containing the status for the specific record.
This works, and isn't too different from what I was wanting to do. However, instead up selecting the status from the combo box, and updating the current record's score, which was my objective, I am now forcing them to select the status by a check box.
The popup form has 3 fields, the identifier, which is what ties it to the current record I'm trying to update, the status to pick from, and now a checkbox, to select which status they are currently at.
Now, if you can please help me. When they select the correct check box, I need the score of that record, to transfer back to the record on the form.

So it would be something (this is totally wrong, but layman's terms for me)
When score is checked, MainForm Score = popform score, where identifier field = identifier field.
ROFL.... I DO NOT claim to know VBA!!!! If nothing, that statement is good for a laugh, right?

Can you help me figure it out based off of my stupidity, please?

[ItsMe]

That sounds like a logical approach. If you are going to offer three selections via a checkbox or radio button I suggest using an option group. It is a control that can be placed on your form and the wizard will guide you through the process of creating it. The idea is that the control will return a value of integer type based on the user's selection. With the value you will have to update the record. You could run an UPDATE query or DAO. It may be easier to accomplish using a combo on your new form. Have the form bound to the table and the combo control source to the field.

One other note, you may get a warning that another user changed the record after you update the table from the second form. You can avoid this by strategically saving the record before and after the combo updates the record.

[jlgray0127]

You rock! That took care of the issue! Thank you so much!!!!