I currently have a query that when I doubleclick an item in a listbox, it opens that item in one of two forms. That query is:
If Me.List93.Column(1) = "Task" Then
DoCmd.OpenForm "Add/Update Tasks", , , "[ID]=" & Me.List93
Else: DoCmd.OpenForm "Add/Update Questions", , , "[ID]=" & Me.List93
End If
End Sub
Column (1) will either say "Task" or "Question". When the Add/Update Tasks form opens with the appropriate record up, it automatically filters the form to only that record so I can't scroll through the other tasks. So if i doubleclick the line for ID #1 in the listbox, and it's a task, it'll open up ID# 1 in the Add/Update Tasks form. Is there something that I can add that when the form opens up, it keeps me on ID #1 (or whichever I selected in the listbox) but refilters the list to only show me all Tasks? I'd like for when the Add/Update Questions form to load, it will keep me on the correct ID, but refilter to only show me all Questions as well. "Task" and "Question" are located within my table "Records" in the column called "Record Type".
Thanks for any help.