Hi,
I am using Access 2003. I have a list box on a form which has 6 columns in it, with data taken from a table. I have an unbound text box which holds the ID number for the selected item in the list box. I have a command button which I want to use to open another form on that record. At the moment it opens the other form but only to the first record. The other form has its recordset set to the same table as what the list box displays certain data for. Basically, the list box displays certain more important data, and the user clicks on the item to be viewed and then the next form displays all the data.
I have used this code to try and open the form to the correct record with no luck:
-
Private Sub cmbSelected_Click()
-
-
Dim stLinkCriteria As String
-
-
stLinkCriteria = "[RiskEstimateID] = '" & Me.txtLstRPET & "'"
-
-
DoCmd.OpenForm "RiskEstimating", acNormal, , stLinkCriteria, , acNormal
-
-
End Sub
-
I have also tried to open the form with OpenArgs with no luck, like this:
-
Private Sub cmbSelected_Click()
-
-
DoCmd.OpenForm "RiskEstimating", acNormal, , , , acNormal, Me.txtLstRPET
-
-
End Sub
-
-
-
Private Sub Form_Open(Cancel As Integer)
-
-
Me.RiskEstimateID = Me.OpenArgs
-
-
End Sub
-
I have tried debugging and going through the code and in theory it should work, but it just doesn't. If say the ID number is 4 for the selected item in the list box, then the value in txtLstRPET goes to 4. For the stLinkCriteria it says "[RiskEstimateID] = '4', but the 4th record doesn't display in the form when opened.
Many thanks in advance,
Andrew
