How to Use Search Form Query Result & GoTo Desired Record on Separate Form

[ANTHROPOIDLUVA]

I ask help in writing code in VBA that allow the following action to be achieved:



Problem: I have two forms [Directory] and [Monkey Bar Search Tool] that I am trying to get them to talk to one another based upon a query result produced by [MBST]. The [D] form does not have conventional fields. Instead, it has concatenated textbox expressions (i.e., = [FIRSTNAME] & " " & [LASTNAME]; ="Staffed as" & " " & [PositionTitle]). A command button on [D] form opens up [MBST] form and allows the user to enter search criteria including First name, Last name, Department number, and Position title. This form is driven by a query [MBSTquery]. Once the Run Query command button is clicked, the query results of the record or associated records based on user input is displayed in datasheet view. I would like query result to automatically go to record (or records) on [D] form, which remains open while user dialogs with the [MBST] form. I am aware of the combo box, but would like to go a different route instead to perform search...just not sure how to connect the dots between the two forms.


I have the following code in place for the [MBST] form:

Private Sub Command67_Click()
DoCmd.OpenQuery "MBSTquery", acViewNormal
End Sub

[June7]

Why open the query?

Options:

1. use query parameters in the RecordSource for form [Directory]

2. code sets Filter and FilterOn properties of form [Directory]