dialog boxes

  • Thread starter Thread starter Nexus
  • Start date Start date
N

Nexus

I have a pop-up box to allow the user to select a
specific record to edit. How is it that no matter which
record I select to edit, the form will still show the
first record in the table?

Here are my codes:
Private Sub cmdEdit_Click()

Dim strCatID As String
strCatID = Me![cmbCatID]
DoCmd.Close
DoCmd.OpenForm "frmTools"
DoCmd.FindRecord strCatID, , True, , True, , True

End Sub
 
yup, it does! Thanks loadz!
-----Original Message-----
Ignore my previous post I was obviously not paying attention when I wrote it.

Try using

DoCmd.FindRecord strCatID, acEntire, True, acSearchAll, True, acAll, True

It works for me.

Regards

Andy W


Nexus said:
I have a pop-up box to allow the user to select a
specific record to edit. How is it that no matter which
record I select to edit, the form will still show the
first record in the table?

Here are my codes:
Private Sub cmdEdit_Click()

Dim strCatID As String
strCatID = Me![cmbCatID]
DoCmd.Close
DoCmd.OpenForm "frmTools"
DoCmd.FindRecord strCatID, , True, , True, , True

End Sub
Click to expand...
.
Click to expand...
 
Back
Top