How to open form using hyperlink datatypes

[b07h]

Hi...

I create a table that have one hyperlink data type and i want to open a existing form that i created using this hyperlink.

Can this hyperlink data type open a form in the same access database? or open form in different access database?

Using hyperlink button have the function to open form in same database but the problem is this function is not available in hyperlink data type.

Please help.

 

[olek_w1]

Hello,

Please note that hyperlink data type is designated to store some external hyperlinks data in your table like web-page address of your custommer etc, so when you have some form with your customer overall data, You can open his web directly from your access form clicking in hyperlink field.

But as i understand - you have some main form (continous form) - with all the records
as continous view - and you want to open some other detail form of already selected record in this main form - you should use action Docmd.openForm with the opening filter containing id of already selected record in main form.

 

[kerrydunk]

Hi There
Can you please let me know how to open the form based on the selected record?
Where exactly would the code go if you were looking at a table?
Thanks