Combo or List Box Error

[MikeSr]

When trying to add a list box or combo box to any form (existing or new), I recive a pop up stating "No valid fields can be found in 'PARTS'. Please select a new source"
Then:
after clicking 'OK', a second popup "Banyan Database can't find the field 'fpk_frmFpk' referred to in your expression.
This pop up occurs one more time.
I havenot selected a source yet. The wizard shows in the background, but the popups take presidence. The object appears finally on the form. I want to fix this error, but can't find the source. Parts table doesn't exist. There was a table I imported from another database that used 'PARTS'.

any help would be appreciated.

 

[JPaulo]

use Compact/Repair in tools to resolve.

 

[Mr. B]

If, after using the compact/repair option as previously suggested, the problem is not resolved, try creating a new database file and then importiing all objects from the existing one and see if that solves the problem.

This shoulds very much like some kind of corruption. If you try both suggestions above and still have an issue, you might try creating the new database file and only importing the objects from the original database file one at a time and test after importing each one. You may find that only one of the objects has the problem and using this method you may be able to isolate that object and just recreate it.

 

[MikeSr]

Tried all of the above. Nothing worked.
I closed Access 2007 and then re-opened it. That solved the problem.
I should have know better to begin with. Thanks for your kind and quick responce. Still don't know why this happened.