Hi guys - long time no speak
i have a report that that i need to be a bit dynamic
If quoteslip = q basically the report does nothing other than how i have already set it up
however if quoteslip w then do stuff
"w" does what i want however "q" doesn't
I have tired we me. etc
the information is in a qry and into the report
so
Hello Baby (w) will start in one location (left/top ) 567
hello Baby (q) should start in another (left3567 and top170)
its not doing what it should and i am sure i have missing something simples
If Me.QuoteSlip = "w" Then
substance.Left = 567
substance.Top = 567
substance.Width = 9735
End If
If Me.QuoteSlip = "Q" Then
Me.substance.Left = 3567
Me.substance.Top = 170
Me.substance.Width = 6205
End If
i have a report that that i need to be a bit dynamic
If quoteslip = q basically the report does nothing other than how i have already set it up
however if quoteslip w then do stuff
"w" does what i want however "q" doesn't
I have tired we me. etc
the information is in a qry and into the report
so
Hello Baby (w) will start in one location (left/top ) 567
hello Baby (q) should start in another (left3567 and top170)
its not doing what it should and i am sure i have missing something simples
If Me.QuoteSlip = "w" Then
substance.Left = 567
substance.Top = 567
substance.Width = 9735
End If
If Me.QuoteSlip = "Q" Then
Me.substance.Left = 3567
Me.substance.Top = 170
Me.substance.Width = 6205
End If