[AccessD] If .. ElseIf

pedro at plex.nl pedro at plex.nl
Fri Jul 18 10:01:02 CDT 2003


Hello Group,

the code below is part of a code that i use for mailmerge.
I want to use the value chbA or chbB or chbC only when chbProduct1 = true. How must the code be changed for this?

TIA

Pedro Janssen



If chbProduct = True then
Item("ProductCode").Value = Nz(Me![txtProductCode])

ElseIf chbA = True then
Item("Number").Value = "2000"
Item("Price").Value = Nz(Me![txtA1])

ElseIf chbB = True then
Item("Number").Value = "3000" 
Item("Price").Value = Nz(Me![txtB1])

ElseIf chbC = True then
Item("Number").Value = "4000" 
Item("Price").Value = Nz(Me![txtC1])

End If





More information about the AccessD mailing list