When opening a form using the Openform statement in VB and using the where argument, the form opens and apparently ignores the Where clause.


DoCmd.OpenForm "frmCustomers", , , "Customer_ID = " & 99,

The form will open and display all the records in the table Customers, not just those with CustomerID = 99.

If I create a new form identical to the original form... the new form works perfectly and the old form still fails.

I really don't want to have to recreate all the forms opened with the Openform statement in the program.

Anyone else experienced this?