K kitty77 Registered User. Local time Yesterday, 23:59 Joined May 27, 2019 Messages 719 Aug 5, 2023 #1 How do I add these two together in on line? If ([standard] <> "apple") And ([frequency] = "annual") Then strDocName = "report1" msgbox "all good"
How do I add these two together in on line? If ([standard] <> "apple") And ([frequency] = "annual") Then strDocName = "report1" msgbox "all good"
Eugene-LS Registered User. Local time Today, 07:59 Joined Dec 7, 2018 Messages 519 Aug 5, 2023 #2 Use a colon to combine lines Code: If (Me.standard <> "apple") And (Me.frequency = "annual") Then strDocName = "report1": msgbox "all good", vbInformation
Use a colon to combine lines Code: If (Me.standard <> "apple") And (Me.frequency = "annual") Then strDocName = "report1": msgbox "all good", vbInformation
K kitty77 Registered User. Local time Yesterday, 23:59 Joined May 27, 2019 Messages 719 Aug 5, 2023 #3 Thanks