Reply to thread

Message: [QUOTE="Allen Browne, post: 2582996"] Create a form, bound to your 3-table query. Set its Default Value to Datasheet if you wish (or Continuous.) You can now use the DblClick event of any control you like to open the other form. The code for the event procedure would be something like this: Dim strWhere As String If Me.Dirty Then Me.Dirty = False 'Save first. End If If Me.NewRecord Then Beep Else strWhere = "MyOtherField = " & Me.[MyIdField] DoCmd.OpenForm "Form2", WhereCondition = strWhere End If Note that that won't work of Form2 is already open. [/QUOTE]