GoToRecord Problem

[HowardChr via AccessMonster.com]

I have the following code in my VB:

DoCmd.GoToRecord , [Response Tasks], acGoTo = [Response_ID], "08"

This is not working however.... The table name is Response Tasks, the Column
name is Response_ID and I am trying to pull the info from the one named "08".
What am I doing wrong in the procedure?

Thanks in advance

 

[Guest]

So you are trying to make the active form display record 08? I think you'd
be better off using recordset.clone

Try something like:

' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[Response_ID] = 08"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark