link to a record on a form

link to a record on a form - subforms

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bigbump - 08 Feb 2008 12:00 GMT

I have created a link from one form to a specific record on another using the
following macro;
Action: Open Form
Where Condition: [ID]=[Forms]![Newspaper Query]![ID]
This works perfect until I try to add the first for as a sub form to my home
page form. When I click the link it first asks me to 'Enter Parameter Value -
Forms!Newspaper Query!ID' If I type in the ID it will take me to the
specified record but this is rather messy.
Am I missing some code with this being changed into a subform?

Reply to this Message

Al Campagna - 08 Feb 2008 13:30 GMT

Bigbump,
Not sure if I understand...
I think you're saying that when your "calling" form was a standalone, the
Where argument worked, but now... when that same form is a subform, the code
fails.
And... if your ID is now on the subform, you should address it as....
(use your own object names)
=Forms!frmMainName!frmSubformName.Form!ID

Signature

hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

>I have created a link from one form to a specific record on another using
>the
[quoted text clipped - 8 lines]
> specified record but this is rather messy.
> Am I missing some code with this being changed into a subform?

Reply to this Message

bigbump - 12 Feb 2008 11:32 GMT

That is brilliant, it is working now, thanks for your help.

> Bigbump,
> Not sure if I understand...
[quoted text clipped - 16 lines]
> > specified record but this is rather messy.
> > Am I missing some code with this being changed into a subform?

Reply to this Message