S
Shytown_Turk
Hello All,
I am usiing Access 2007 and I have a form that contains three subforms that
are used to review data. Specifically, the first subform (fsubData_List) is
a list of all the records in the datasource. The second subform
(fsubData_search) contains an edit button and is going to be used to search
and filter from the entire dataset. The third subform (fsubData_detail) is
used to list all of the detailed information for the record selected in the
first subform. This is done via a hidden field call txtRelay which is used
to store the unique ID for the selected record. This all works fine, but my
problem involves trying to link the selected record to a pop-up form that is
used for editing the selected record. Basically the user selects a record in
the first subform and then the complete information in presented in the third
form. The second form contains an edit button that when selected should
pop-up another form (frmData_edit) where the user would then be able to
change the specific record's information. I have attached my current code,
but it doesnot populate the popup form with any data.
Thank you in advance for any assistance,
Shaun
-----------------------
Private Sub cmdEdit_Click()
If Not IsNull(Me!txtRelay) Then
DoCmd.OpenForm "frmSecurity_Update", _
WhereCondition:="[txtRelay] = " & _
Chr(34) & Me!CUSIP & Chr(34)
End If
End Sub
I am usiing Access 2007 and I have a form that contains three subforms that
are used to review data. Specifically, the first subform (fsubData_List) is
a list of all the records in the datasource. The second subform
(fsubData_search) contains an edit button and is going to be used to search
and filter from the entire dataset. The third subform (fsubData_detail) is
used to list all of the detailed information for the record selected in the
first subform. This is done via a hidden field call txtRelay which is used
to store the unique ID for the selected record. This all works fine, but my
problem involves trying to link the selected record to a pop-up form that is
used for editing the selected record. Basically the user selects a record in
the first subform and then the complete information in presented in the third
form. The second form contains an edit button that when selected should
pop-up another form (frmData_edit) where the user would then be able to
change the specific record's information. I have attached my current code,
but it doesnot populate the popup form with any data.
Thank you in advance for any assistance,
Shaun
-----------------------
Private Sub cmdEdit_Click()
If Not IsNull(Me!txtRelay) Then
DoCmd.OpenForm "frmSecurity_Update", _
WhereCondition:="[txtRelay] = " & _
Chr(34) & Me!CUSIP & Chr(34)
End If
End Sub