Results 1 to 1 of 1
  1. #1
    Join Date
    Aug 2003

    Unanswered: OpenForm with Where clause fails

    When opening a form using the Openform statement and Where clause in VB the form opens apparently ignoring the Where Clause.

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

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

    I can create a new form exactly like the original form and it will work perfectly. The old form still fails.

    I really dont want to have to recreate all my forms.

    Has anyone else experienced this?

    Any ideas?

    Last edited by jnason; 09-23-03 at 20:47.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts