Go To Record

[naomir]

Hi I have a question regarding the "go to record" macros.

I want to use the goto record option so that when I'm working on table A record 333 I can open Table B and record 333 will automatically be open.
I'm not entirely sure how to do this, everytime I try to write an expression it informs me that I need to use a number.

Does anyone know how to solve this?

Thanks.

 

[The_Doc_Man]

You don't indicate the context of this operation. Is the macro running behind some VBA code or as a database-window macro?

If it is VBA code, there are many ways to do it. But if it is a macro, I don't use those often enough to be able to help you much.