Question How to solve this problem

[ibrahim horus]

hello Sir..
I designed this database, you design a form to search (qc1) and when I type the name of research and appears in the search result, and then double clicking on the name I want to form shows TmpPat

 

[GinaWhipp]

Not sure if this is what you are asking for but the below is to open another Form from a Main Form via a button but can also be used in the Double_Click event of a Control...

If field is numeric…

DoCmd.OpenForm "YourFormName", , , "[NameOfFieldFromDataSource]=" & Me![NameOfFieldOnFormOpeningFrom]

If field is text…

DoCmd.OpenForm "YourFormName", , , "[NameOfFieldFromDataSource]='" & Me![NameOfFieldOnFormOpeningFrom] & "'"

 

[ibrahim horus]

thanks GinaWhipp but there are sum problem

 

[GinaWhipp]

What Sum problem, please describe...