Search results

Thank you missinglinq, Your suggestion was useful for me too.

I did some debugging, the code was stopping at: Forms(stDocName).COMPla = COMPl i changed to : Forms(stDocName).controls(COMPla).Value = COMPl then it worked like charm. Thanks a lot to you and Gizmo for help

Hi Gina, Thank you, I tried your sql code, its the same as before. I guess i am not able to assign query value to the text field. either do loop failing or Forms(stDocName).COMPla = COMPl is not able to pass on the result to the text field. its my guess , I am not sure. If i do not use for...

Sorry forgot to post examples: ENCRYPT_ID have values like- CIMP001, CIMP002, CIMP003 etc CMPL_RULE_ID have values NUM01, NUM02 ..... NUM10

Both ENCRYPT_ID and CMPL_RULE_ID are string variables. I do not have any field with numbers.

I again got same error message.

Thank you, I modified as you suggested, and the msgbox I received is attached.

Thank you Gizmo, Here is the message i got : >>>SELECT DISTINCT HEDIS_HYBRID_CMPL_ALL.[compliance]FROM [HEDIS_HYBRID_CMPL_ALL] WHERE HEDIS_HYBRID_CMPL_ALL.ENCRYPT_ID = 'CIMP109' And HEDIS_HYBRID_CMPL_ALL.CMPL_RULE_ID = 'NUM01' When i click OK, i again get original error message...

HI I am new to VBA, I am trying to populate 10 textboxes with values from a table. I am getting "Application-defined or object-defined error" when I open the form. Can you please find where is it going wrong? Text boxes are named compl_01 to compl_10. And NUMer value in sql is supposed to...