Finding a record number based on a primary key

[Guest]

Hello, I have a form and I would like one of the controls in the form to link
back to a specific record in a table. The form itself is based on the search
results from a previous form. The controls in the form are "Case Number",
"Citation", and "Parties-Appellant." In the first search form a user will
type in the name of a particular "Parties-Appellan", say "John Smith", then
click a "begin search" button. The results of the search come up in a second
form, with the three controls I cited above. "Case Number" is the primary
key for a table on which everything is based. The user wants to be able to
click in the search results form, in the "Case Number" text box and be taken
back to the original form where the case number information was added. I
hope this is clear. I can't figure out how to do this! I tried a hyperlink
but that doesn't seem to work well. Thanks so much in advance.

 

[Guest]

It seems like all you need to do is to close the current form then open the
other form passing the key (case numb) in openargs. In the open event of the
second form use the openargs value (case numb) to position on the data you
want.

Dorian