Checkbox Value Changes

[WillM]

Good morning all,
I have a form that contains a listbox that a user can select multiple items from, and that listbox will then populate a subform with those selections.

There is a combo box with multiple outcomes for those selections, in the subform, and all selections must have an outcome.

If a selection is marked as a follow-up, the next time that particular ID number is entered into the form, the follow-up items automatically populate the subform, and show as a new item. I realize this is potentially problematic, but it does work right now. I am open to alternative suggestions.

I have marked the items as follow up with an invisible check-box, depending on what the user selects as an outcome. There are two statuses that require follow-up and two that do not.

The problem I have is that when the prior items are pulled forward, I don't know how to clear the check box of the first iteration of that item. So what happens is that the original follow-up items are pulled forward every time the ClientID is entered into the system.

Here is an example:
ClientID 1000
CaseId1, ProbID1 = problem 1, outcome Followup
CaseId1, ProbID2 = problem 2, outcome NoFollowupNecessary
CaseId1, ProbID3 = problem 3, outcome Followup

The next time the ClientID is entered:
ClientID 1000
(these are auto-added from the previous case, new problems can be added below these)
CaseID2, ProbID4=problem 1
CaseID2, ProbID5=problem 3

So again, the problem is marking the problems to be able to be pulled through to the next case for follow-up, but then going back to those exact same problems and removing the check in their boxes respectively.

Thanks for reading it over,
WillM

 

[mh123]

Hi

Can you please post a copy or ss of the form you are referring to - been a long day struggling to visualise this!!!

Does the user not have the option to set the status for problems??

 

[smig]

Why not saving the data in a table for next time reading ?

 

[WillM]

Good morning folks, I actually ended up solving this yesterday evening. The over simplified explanation of what I did:
I used a strSQL statement that updated the table, set the value of the box to false, where the ID's matched. ReviewID(main form) and FUID(sub form) are the same number.

strSQL = "Update tblMytable Set FollowUpItem = False WHERE tblMyTable.ReviewID = " & Me!subfrmProblems.Form!FUID & ""

Thanks for the responses, I appreciate it!