Strange error

G

george

Microsoft Access cannot find the field "|" refered to in your expression this
happens when i open my members table but it does not stop anything ??????,
the table still opens up.

I have tried to look for this expression but to no avail.

george
 
K

Ken Snell [MVP]

Do you have any "lookup" fields in the table? Check the expressions used as
the RowSource of those fields.
 
A

Allen Browne

When the table opens, do any of the fields show up as a combo box?

If so, you have used the Lookup Wizard, or set the Display Control property
(lower pane in table design, on the Lookup tab) to Combo Box or List Box.
There's a fairly good chance that something is wrong with the SQL statement,
table, or query that serves as the RowSource for this combo/list box.

If that is not the case, then your database is corrupt, with Name
AutoCorrect being the likely culprit. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect.
Then compact the database:
Tools | Database Utilities | Compact
Post back if this does not solve it either, and we will provide further
instructions on recovering from corruption.
 
Top