Forum Discussion

Tony2021's avatar
Tony2021
Steel Contributor
Jan 03, 2022

Open Report (strip out letters for Where clause)

Hello Experts,   I have the following OpenReport code:  DoCmd.OpenReport "rptPC", acViewReport, , "[DDNo]= " & Me.txtDrawNo I need to modify it since [DDNo] is not a number...it's text. There is...
access
  • George_Hepworth's avatar
    George_Hepworth
    Jan 03, 2022

    Tony2021 


    Try this and let us know if it is successful or not.

     

    DoCmd.OpenReport "rptPC", acViewReport, , "[DDNo]= """ & Replace(Me.txtDrawNo, "DD","") & """"

George_Hepworth's avatar
George_Hepworth
Silver Contributor
Jan 03, 2022

Tony2021 


Try this and let us know if it is successful or not.

 

DoCmd.OpenReport "rptPC", acViewReport, , "[DDNo]= """ & Replace(Me.txtDrawNo, "DD","") & """"

  • Tony2021's avatar
    Tony2021
    Steel Contributor
    Jan 03, 2022
    perfect. thank you very much.

Resources