Go to specific record in a subform

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Wayne Robinson - 28 Oct 2004 14:32 GMT

I have a subform that lists many records (obviously). I want to be able to
go to a main form with the record that the user is current focused on (the
record selector is pointing to). I don't know the control name to do this,
is there a way with a macro?

Kindest regards,

Wayne

This email and any attachment have been scanned by Norton and are believed
to be virus free.

Reply to this Message

Steve Schapel - 28 Oct 2004 19:17 GMT

Wayne

Presumably you will have a Primary Key field included on the subform.
Let's suppose it is called [ID]. Use an OpenForm action in your macro,
and in the Where Condition argument, put the equivalent of....
[ID]=[Forms]![NameOfForm]![NameOfSubform]![ID]

Signature

Steve Schapel, Microsoft Access MVP

> I have a subform that lists many records (obviously). I want to be able to
> go to a main form with the record that the user is current focused on (the
[quoted text clipped - 4 lines]
>
> Wayne

Reply to this Message

Wayne Robinson - 29 Oct 2004 04:21 GMT

Steve, You are the Best!

I have tried everything having to do with a record and never thought of the
ID field. Thanks so much.

Wayne

P.S. I'm a tax guy (who likes fiddling) building a research database. It has
turned out pretty well, but still needs some tweaking. I have gone back in
my forms and built defaults based on whether the item is taxable or exempt
etc. (I'm also a user so the less mouse clicks the better!).

Thanks again, I hope one day I can give someone advice.

Reply to this Message

Steve Schapel - 29 Oct 2004 05:47 GMT

Best wishes, Wayne. Doesn't matter where you've got to, there's always
more to learn, but it sounds like you are enjoying the process, which is
wonderful.

Signature

Steve Schapel, Microsoft Access MVP

> Steve, You are the Best!
>
[quoted text clipped - 9 lines]
>
> Thanks again, I hope one day I can give someone advice.

Reply to this Message