link between a continuous form's data and a more detailed form

[akbigcat86]

I have a continuous form that lists the basic data for a number of records. I also have a single form that has the more detailed data for the same records. Is there any way to make a hyperlink/command button of some sort that I can click on while looking through the continuous form that will send me to that same record in the more detailed single form?

Thanks in advance!

[cowboy]

This is the code I have for a command button on click event from my continuous form. It sets a global variable with data from that specific record so it knows which form to open, this could be your primary key. Then set your other form to use the global variable as a way to determine what information it is displaying.

This is only one way to do it, there are lots of other options.

Private Sub btnMonth_Click()
    gDteDate1 = Me.Text36.value
    DoCmd.Close
    DoCmd.OpenForm "f_Month"
End Sub

[RuralGuy]

When you click on a record in a Continuous Form, that record becomes the Current Record. Does that give you any ideas?

[akbigcat86]

So I have to select the record first and then click any command button I add to the form? Is there any way to make it so clicking the command button of one record (not the current record) on a continuous form brings me to another form that displays the details of that record?

[cowboy]

the way i described will work in the way you are thinking.

[akbigcat86]

I figured it out myself. I didn't realize a command button on each line in a continuous form would still bring up data associated with that record. Thanks for the help though!

[RuralGuy]

Outstanding! We love it when posters are able to get a handle on their own issue.