Sort subform records on numeric values stored in a text field on Main Form

[June7]

Doesn't alter my comments.

[Green]

I understand, just thought you would like to see what we were talking about.

Thanks for the help.

[June7]

Okay, you have a plan for fixing?

The sequence string is saved with every record on the main form?

A VBA custom function might be able to get the record's sequence from the string. Something like:

Function GetSeq(intTask As Integer, strSeq As String) As Variant
Dim aryTasks As Variant, x As Integer
GetSeq = Null
aryTasks = Split(Replace(strSeq, " ", ""), ",")
For x = 0 To UBound(aryTasks)
    If intTask = Val(aryTasks(x)) Then
        GetSeq = x
        Exit Function
    End If
Next
End Function

The function would be in a general code module and can be called from a query, like:

GetSeq([TaskID], [Sequence]) AS SeqID

That query would be a join of the parent and dependent tables so that the Sequence field is available.

Be aware, custom functions called from query can cause slow performance.

[Green]

I did not have a plan for fixing but what you have provided sounds like the best option forward.

The sequence string is saved with every record on the main form.

I am not too concerned with slow performance as much a visually see the tasks in a sequence for the user.

Thank you very much for this!

[June7]

If you use the query as RecordSource for subform, do not use INNER JOIN.