hyperlinks

K

Kevin

I have a form called "ES Missions by Region" displayed in datasheet view in
which I'd like to put a hyperlink for each record which would open a
corresponding record in another form "ES Missions by Country". So clicking on
say "Tanzania" on the first form would open the record for "Tanzania" on the
second form. How could I do this? I'd really appreciate any help!
 
S

Stefan Hoffmann

hi Kevin,
I have a form called "ES Missions by Region" displayed in datasheet view in
which I'd like to put a hyperlink for each record which would open a
corresponding record in another form "ES Missions by Country". So clicking on
say "Tanzania" on the first form would open the record for "Tanzania" on the
second form. How could I do this? I'd really appreciate any help!
Click to expand...
The only thing in know you can do:

Use the double click event of the corresponding textbox.


mfG
--> stefan <--
 
A

Albert D. Kallal

Does each record have a primary key (autonumber) ?

By the way, you don't need, nor want to use a hyper link. just place a
button on the continues form.

the code behind the button can be

me.Refresh ' this is NOT needed if you don't allow
' editing in the continues form

docmd.openform "your 2nd form",,,"id = " & me!id

The above assume that you have a primary key field called id

As for how the button looks on the continues form, here is some screen shots
of continues forms..and note how some of the examples have a button to
"open" the continues form to the one record for view/editing. The example
screen shots use the above code do accomplish this.

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

(and, the above screen shots will give you some other ideas as how to
display details of each record -- such as using two sub-forms side by side)
 
K

Kevin

Sorry for the late reply but thanks very much for your help. i've actually
decided to use a different method altogether, i.e. having everything together
 
K

Kevin

Hi, thanks so much for your reply and sorry this is coming so late. Your web
site examples are really good (and I've shared your website with others in
the office) but I still have a problem:

I've changed my approach and now am using filters (Me.Filter method) with
two combo boxes on my form to display records relating to travels by region
and by country respectively. I would like to link both combo boxes so that as
in your example on your website the first combo boxfilters the choices in the
second. However, when I attempt to add your code nothing happens, and also
when I remove the Me.Filter code as well.
How can I successfully link the two combo boxes?

Thanks much in advance.
 
Top