Using Sub Forms to select Main Form records

[mokkfive]

What is the best way to have a continuous sub_form pick the record that the main_form is showing. (same table/query)

bookmarks? find_records?

also if the main form changes record have it change the sub_form selection.

i have tried the following code:

    Dim rst As Recordset
    Dim strCriteria As String
 
    Set rst = [Form_Item].RecordsetClone
    strCriteria = "[Inv ID] = " & [Inv ID]
    rst.FindFirst strCriteria
    If rst.NoMatch = False Then
        [Form_Item].Bookmark = rst.Bookmark
    End If
 
    Set rst = Nothing.

Which "sorta" works. It will work once, then wont, then will. Which is weird.

I used to do this easily with a combo box, but i want color changes, so i need a subform.

Im trying to have two subforms control the record.
The 1st subform has ALL the records
The 2nd subform has records associated with the current.

[NeoPa]

I'd use a filter myself.

Unfortunately, I find the question very unclear as you don't explain which of the items you include in your code refer to which items in your question. The question has a 'Main_Form', but the code doesn't. The most important part of the code would be the procedure header, as that would hopefully give some clues, but that part is strangely omitted from the question.

Look, I understand that formulating questions clearly is much more difficult than you'd guess until you try it, but this could be made a lot clearer by considering what information we need and explaining it consistently.

For what we have here though, I would recommend using the selected record of the subform to set a filter in the main form.

[zmbd]

Let me see if I understand:

Are you developing/emulating a "Split Form:"

The main form would have an "Index Card" style format wherein one can see the all of the information in the record fields; whereas, the table would show the same information; however, not in such an easy to read format.

Is that correct?