Compile Error

[Pooh]

I have a button on a form that has an 'on click' expression to bring up a query.

I copied and pasted this button and edited the expression to create another button that would bring up a different query.

Since then ANY button I press on the form (not only the one I copied) gives me the message:

Compile error in 'onclick' expression.

Can anyone help?

The form is not bound to anything.

 

[MStef]

Check VBA, it must be a mistake somewhere.

 

[Pooh]

compile error

sorry, very new to this, how would I do that and if it is an error would it affect every button on the form?

 

[MStef]

It depends on you, what you write in VBA.

 

[Pooh]

Can you advise me how to check this out or direct me to somewhere where it might explain about the VBA as I don't understand what I have done wrong. I was not aware that I changed anything that would affect everything on the form, just thought it would affect the button I was trying to copy.

Thanks, Elaine

 

[MStef]

Send a short example of your MDB, (zip), (access 2000 or 2002).