GoToRecord Problem

  • Thread starter HowardChr via AccessMonster.com
  • Start date
H

HowardChr via AccessMonster.com

I have the following code in my VB:

Code: 
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
 
D

Daniel

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
 
Top