Hyperlink to Form

[Mackbear]

Hello everyone!

Reaching out for help again, I have a datasheet form (image attached). I have made one of the fields displayed as hyperlink, I am trying to make the "hyperlink" show the "contents" filtered in a form view upon clicking on the "hyperlink". I tried the openform macro and on the condition I entered ="[PMC]=" & [PMC], but it only opens the form without the filter. Help! :banghead: Thank you very much in advance!

 

[Gasman]

PMC looks like text?

Text generally needs to be surrounded with single quotes.

Try

="[PMC]=[COLOR="Red"]'[/COLOR]" & [PMC] & "[COLOR="red"]'[/COLOR]"

HTH

 

[Mackbear]

Thank you very much!, I missed that, I was following a code I saw that used the primary key which is a number. . Thank you, I appreciate it!

 

[Gasman]

FWIW if you ever get to use dates, they should be surrounded by #.

 

[Mackbear]

I have come across another issue, I am trying to add another criteria to filter and now my code is ="[PMC]='" & [PMC] & "' And [cbstatus]='In Progress'". cbstatus is a field in the table of the other form I am trying to open. and the value I would like to filter is if it is In Progress. Not sure what I was missing. It is asking me for a parameter value

 

[Gasman]

No, you only put the single quotes around the criteria

="[PMC]='" & [PMC] & "' And [cbstatus]='" In Progress & "'"

 

[Mackbear]

No, you only put the single quotes around the criteria

="[PMC]='" & [PMC] & "' And [cbstatus]='" In Progress & "'"

Awwwtz it says I have invalid value on the criteria

 

[Gasman]

Inspect each variable.
That code expects a value for each variable. If one could be empty/null, you would need to do extra.

 

[Mackbear]

Thanks I got it working now! = )

 

[Gasman]

Thanks I got it working now! = )

For the benefit of others, please explain what the problem was and how you solved it.

TIA

 

[Mackbear]

For the benefit of others, please explain what the problem was and how you solved it.

TIA

I apologize for the late reply, i checked it and i realized that i have the field name incorrect so it was fixed when i corrected the field name cbstatus to status. Thanks for your help everyone!