I have been using Access since the beginning and I have never encountered this before. I have a button on a form that opens a query. The query has a parameter set using Forms!myform!myfield to filter the records. This keeps breaking, in that it no longer recognizes the field on the form. If I change the myfield in the query to a new reference and change the name of the field on the form to the new reference all works fine, until I close the form and reopen. Then it no longer works. I can again change the reference and it works fine again, until I close the form.
Anyone have any clues why this keeps breaking. I have run Compact and Repair.
TIA