Incorrect Syntax near '!'

[jluost1]

I have a form with a button. Click on the button will run a macro. In the macro, there is an openForm action. The "WHERE" property is set as the following:

[Bkg Ref#]=[Forms]![Client]![Bkg Ref#]

Each time when I click the button, I got the error:

line1: Incorrect Syntax near '!'.

The error message gives me error information about the macro. It indicates the error was the "WHERE" property.

Any idea?

Thanks a million.

 

[jluost1]

By the way, I am using ACCESS 2000 with ADP file and SQL Server 2000 as the front end and backend.