Linking two forms

[JeffG3209]

I have two forms.
MTD
MTD Navigation

MTD contains specific details of each record.
MTD Navigation is rows of records.

The question is how do I link the navigation form to the details? Specifically, how do I make it where when I click a row it will go to the other form details. I used the "multiple forms" under form design. I'm new to all of this so please bear with me

[Bwilliamson]

You will want to go to your Database Tools Tab and select relationships. Add both tables and then create a "join" by draging and dropping the Primary Key field between the two which will draw a line between the two tables. Right click on the line and edit relationships. Select Join Type. Select option 2 all records from MTD and only those from MTD Navigation where the joined fields are equal. That should get you what you need.

Good luck!

[JeffG3209]

I actually only have one table named DATABANK. Can I still do this?

[Bwilliamson]

Sorry, I misread. Thought 2 forms was 2 tables.

You'll need to create a Event Procedure using VBA, probably at the On DBl Click action on the Navigation form with something like:

 
Private Sub Navigation_DblClick(Cancel As Integer)
 Dim strNav As Variant
 
 strNav = "[Field name]"
    DoCmd.OpenForm FormName:="frmMTD Navigation", WhereCondition:=strNav
 End Sub

Then the following screen will need to have a filter on the Data property tab of [Field name].