GoToRecord procedure

[HowardChr]

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

 

[Alc]

Does [Response Tasks] need to be in quotes?

 

[RuralGuy]

I believe you might be mixing up two different functions. Are you trying to do a DLookup()?

 

[HowardChr]

I believe you might be mixing up two different functions. Are you trying to do a DLookup()?

Well.... I'm trying to have my program pull in info from a table into a form. I have been able to have this work using the code: "DoCmd.GoToRecord , , acNext", but now I am trying to pull in one specific record, not just 1 of 3.

 

[boblarson]

Instead of using the GoToRecord part, maybe you should think about using the Filter instead if you want to focus in on one record. You can include a button to unfilter the recordset if you wanted to allow the user to go back to the main recordset when they are done.

 

[mafhobb]

Hi Boblarson, I have a similar problem.

I have been trying to solve a Gotorecord sort of problem. Can I ask for your help?

I have this db all done and I need one final thing. The box on the top left is a search box. Anything record that matches the test string in that text box shows up in the list box on the right. Now all that is left to do is to make it so when I click on the item I want on the list box, the form and subform get updated to that record. Basically a "click-on-the-name in the list box and your record will show up ready to edit below"

Some guys have already been helping me (Thanks!), but this last thing is just not working. What am I doing wrong? Should I use a GoToRecord macro? How do I capture the record# from the box after clicking on it?

A million thanks in advance!

mafhobb