what are the XX andd YY !?

[joe55555]

i have a command button in access with the following event code:

Private Sub Search1_AfterUpdate()
XX = [Search1]
YY = "*" & [Search1] & "*"
[Search1] = YY
Forms![Frmsearch]![FrmSrch].Requery
[Search1] = XX
End Sub

[Search1] is the name of the button

just like that alone without any other code in the vba.


how are the XX and YY used without any declaration ?

[June7]

If the module header does not have the line Option Explicit then variables don't have to be declared. Should always add that line to module headers.

[joe55555]

it has only Option Compare Database and then the code i posted.
isn't suppoed to show an error for not declaring XX and YY?
what would the XX and YY role be if they're not declared !!

i'm sorry maybe my questions naive, but i didn't understand it :S

[June7]

Type Option Explicit into the header just below Option Compare Database. Now the error message will show when you run Debug>Compile.