{"id":104,"date":"2013-10-07T21:36:48","date_gmt":"2013-10-08T01:36:48","guid":{"rendered":"http:\/\/access-diva.com\/blog\/?p=104"},"modified":"2018-07-04T19:37:47","modified_gmt":"2018-07-04T23:37:47","slug":"hyperlink-to-open-forms","status":"publish","type":"post","link":"https:\/\/access-diva.com\/blog\/?p=104","title":{"rendered":"Hyperlink to open Forms"},"content":{"rendered":"

You’re using a Continuous Form,\u00a0you can’t fit all your fields on the Form but you need to see and\/or edit the record and you don’t want to use a Command Button.\u00a0 (Sample file located at the bottom of the article.)\u00a0<\/span> Here’s an alternate way to open the record with a Field…<\/p>\n

\"Client

Client List<\/p><\/div>\n

a. Put an UNBOUND field on your Form and enter the below as the Control Source (Figure 1). \u00a0Note, where cpClientID<\/strong>\u00a0is my Autonumber\u00a0and Primary Key\u00a0you should replace with your Autonumber and\/or Primary Key…<\/p>\n

\r\n=IIf(IsNull([cpClientID]),"(New)","Open")\r\n<\/pre>\n
\"Open
Figure 1<\/p><\/div>\n
b.\u00a0 In the Properties Sheet<\/strong> window for your Field set the Display As Hyperlink<\/strong> to Always<\/strong>.\u00a0 Note, you can leave the Font Color<\/strong> as Hyp<\/strong>erlink Color<\/strong> or change to any color you like.\u00a0 However, since most Users are accustomed to the blue it is safer to accept the default Font Color<\/strong> of Hyperlink Color<\/strong>.<\/p>\n
\"Figure
Figure 2<\/p><\/div>\n
c.\u00a0 Now, just add a bit of code the On_Click event to open your details form (See sample of my frmClientProfile below)…<\/p>\n
\r\nIf (IsNull(txtClientID)) Then\r\n    'If the Field displays (New)\r\n    DoCmd.OpenForm "frmClientProfile", , , ,acFormAdd\r\nElse\r\n    'If the\u00a0Field displays Open\r\n    DoCmd.OpenForm "frmClientProfile", , ,"[cpClientID]=" & Me![txtClientID]\r\nEnd If\r\n<\/pre>\n
\"frmClientProfile
frmClientProfile ~ New Record<\/p><\/div>\n
\"frmClientProfile
frmClientProfile ~ Existing<\/p><\/div>\n
To download a sample file click here<\/a>…<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
You’re using a Continuous Form, you can’t fit all your fields on the Form but you need to see and\/or edit the record and you don’t want to use a Command Button. (Sample file located at the bottom of the article.) Here’s an alternate way to open the record with a Field…<\/p>\n
Client […]<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[74,71,44],"tags":[20,58],"class_list":["post-104","post","type-post","status-publish","format-standard","hentry","category-controls","category-forms","category-text-boxes","tag-forms","tag-hyperlink","odd"],"_links":{"self":[{"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/104","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=104"}],"version-history":[{"count":12,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/104\/revisions"}],"predecessor-version":[{"id":443,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/104\/revisions\/443"}],"wp:attachment":[{"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=104"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=104"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/access-diva.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=104"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}