Go to specific record in a subform

  • Thread starter Thread starter Wayne Robinson
  • Start date Start date
W

Wayne Robinson

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.
 
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]
 
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.
 
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.
 
Back
Top