Pop Up Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to get a record to dispaly as a pop up from a subform embeded
into an 'overiew' form. Below is the code that I am using in the doubleclick
event of the subform.

Private Sub TipTitle_DblClick(Cancel As Integer)
DoCmd.OpenForm "Tip", , , "myPKField=" & Me.TipList.Form.TipNumber
End Sub

Where

TipList is the name of the subform embeded into the main form

TipNumber is the name of the field that contains my primary key

however I keep getting a 'Method or Data Memeber not found' on the subform
container (TipList)

What am I doing wrong?
 
Martin said:
I am trying to get a record to dispaly as a pop up from a subform embeded
into an 'overiew' form. Below is the code that I am using in the
doubleclick
event of the subform.

Private Sub TipTitle_DblClick(Cancel As Integer)
DoCmd.OpenForm "Tip", , , "myPKField=" & Me.TipList.Form.TipNumber
End Sub

Where

TipList is the name of the subform embeded into the main form

TipNumber is the name of the field that contains my primary key

however I keep getting a 'Method or Data Memeber not found' on the subform
container (TipList)

What am I doing wrong?
Click to expand...

Is TipList is the name of the subform control on the form, or is it the name
of the subform itself? You need to use the name of the subform control for
this to work. Also, make sure TipNumber is the name of a control on the
TipList form.

Carl Rapson
 
Click on the sibform control itself (not any control inside it) and open its
Properties window. On the Other tab, the control name is in the Name
property. The name of the subform that the subform control contains is in
the Source Object property on the Data tab. If the names are the same, I
would recommend that you change the name of the subform control to avoid
confusion.

Carl Rapson
 
Back
Top