Link Back to Form from Queries

[MikeHawk]

I am trying to determine the best method for linking back to a form from Queries.

I have a Form that has info filled out for customer service calls that come in. Among which is a case#. From the Log of information stored from these forms queries have been made to organize the info in different ways; all of which have the case#. What I am trying to do is that in looking at a the queries I want them to be able to click on a case number and be transferred to the appropriate form. This way they can update the form as the case progresses.

FYI I am new to Access, and I am trying to improve upon what was created by another. Any help is welcome and appreciated.

 

[marlind]

The best way I found to get the correct code is to open the form you want to use with the case number. Then go to your query under the case number and by the Criteria select build forms loaded forms and then the form you are wanting to use your selection from. Under the column Expression Categories you will see the list of items on the form. You should be able to select from that for example I just did one for dates
Between [Forms]![frmcountselection]![mystartdate] And [Forms]![frmcountselection]![MyEndDate]
Hope this helps.