Error '3008'

[RexesOperator]

I am using A2003.

I changed the name of a field from InvoiceNumber to INVOICENUM in a table called tblTransactions.

It is used in a couple of forms and reports.

On one in particular, based on a query called qryTowerLog (which is based in part on tblTransactions), I double click on a text box called txtINVOICENUM (a character field) and I go to that record in a different form (frmTransactionsMain) using this code:

Private Sub txtINVOICENUM_DblClick(Cancel As Integer)

DoCmd.OpenForm "frmTransactionsMain", , , "[INVOICENUM] = '" & Me.txtINVOICENUM & "'"

End Sub

I do the same thing with a text box called txtFILENUMBER that takes me to the same record using this code:

Private Sub txtFILENUMBER_DblClick(Cancel As Integer)

DoCmd.OpenForm "frmTransactionsMain", , , "[FILENUMBER] =" & Me.txtFILENUMBER

End Sub

FILENUMBER is a numeric field

This did work before I changed the name of the field to INVOICENUM, but now I get the following error message:

"The table 'tblTransactions' is already opened exclusively ..." The thing is there are no other queries/tables open (that I can tell).

I get the same error message on both text boxes.

I did try compact and repair and loading into a new db - but so far no joy. I also tried changing the name back to INVOICENUMBER. But that didn't help either. What am I missing?

 

[boblarson]

I hope you had turned off Name AutoCorrect. If not, you may be suffering from corruption caused by it.

See here for more about that:
http://allenbrowne.com/bug-03.html

 

[RexesOperator]

Yes I had it turned off. This is a relatively simple form so I will rebuild it. This does get a bit frustrating though.