ContributionsMost RecentMost LikesSolutionsRe: Text Lookup field shows "error displaying report" instead of valueThanks, Mike! Will keep note of your suggestion should the bug resurface. ------------------------------ Melanie M. ------------------------------ Re: Text Lookup field shows "error displaying report" instead of valueI think you are right about it being a bug. I made another lookup field and now they both show correctly...strange. I will try the same for the TP Model field. Thanks, Mark - have a great weekend! ------------------------------ Melanie M. ------------------------------ Re: Text Lookup field shows "error displaying report" instead of valueThanks, Mark! Here are the settings within field properties: ------------------------------ Melanie M. ------------------------------ Text Lookup field shows "error displaying report" instead of valueI have two text lookup fields that are displaying the same error: However, the same two lookup fields display properly in the form for the child table: Is anyone familiar with this error and how to resolve? Please let me know what additional information is needed to assist. Thanks in advance for your help! ------------------------------ Melanie Mercadel ------------------------------ Re: Formula URL Syntax Error (Case Function)I think I figured it out. Why is it that you can try to resolve something for an hour, finally decide to ask for help, and then the solution comes to you right after you request help? I added &" to the second to last line: "Early Phase (Clinical)","20") &" QB then allowed me to save the field, and appears to be applying the Case function as intended. I do have a follow up question though: After I saved the field and reopend it, the last line of code appears as: "Early Phase (Clinical)","20") &"\n&_fid_38=" & [Record ID#] & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=er&rid=" & [Record ID#]) Any idea why the \n was automatically added here: &"\n&_fid_38? ------------------------------ Melanie Mercadel ------------------------------ Formula URL Syntax Error (Case Function)Hello - I'm unable to resolve a syntax error. I copied a formula and tried to add a Case function, but am now getting a syntax error. The original formula that works fine: URLRoot() & "db/" & [_DBID_TP_MODEL_RESOURCE] & "?a=API_AddRecord&apptoken=dkmnkvc6xxfffbyjn4imbopoynw&_fid_55=32&_fid_38=" & [Record ID#] & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=er&rid=" & [Record ID#]) The edited formula with the error: URLRoot() & "db/" & [_DBID_TP_MODEL_RESOURCE] & "?a=API_AddRecord&apptoken=dkmnkvc6xxfffbyjn4imbopoynw&_fid_55=" & Case([TP Model Def - Name], "Clinical","32", "Syn One","27", "GCS","23", "REMS","25", "FSP","29", "Systems Only","1", "Early Phase (Clinical)","20") &_fid_38=" & [Record ID#] & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=er&rid=" & [Record ID#]) The syntax error highlights the first underscore in the first bit on the last line "&_fid_38..." Thanks in advance for your help! ------------------------------ Melanie Mercadel ------------------------------