dialog boxes

[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

 

[captain747480]

Have you tried using Docmd.GotoRecord instead

 

[Nexus]

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

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

.