GoToRecord Problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

HowardChr - 07 May 2007 16:14 GMT

I have the following code in my VB:

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

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

Reply to this Message

Daniel - 07 May 2007 17:38 GMT

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

Signature

Hope this helps,

Daniel P

> I have the following code in my VB:
>
[quoted text clipped - 5 lines]
>
> Thanks in advance

Reply to this Message