The great postings around the blogsphere just keep coming. I am not complaining as the body of knowledge they provide to community is growing all the time.
My buddy, Mariano Gomez, who is a wealth of knowledge and is always willing to help on the newsgroups has come with a great article explaining why you should ensure you link prompts when working with Modifier and Dexterity.
Mohammad Daoud has also created a really useful article which discusses how to resolve VBA (Visual Basic for Applications) reference errors. These are usually caused by the removal of a field from a form or report without removing the VBA reference first.
To remove the VBA references to fields no longer needed or available, follow the steps below:
Copy the VBA code into a Notepad.exe window.
Remove the Report or Window from VBA (Tools >> Customize >> Remove Current Window/Report from Visual Basic).
Add the Report or Window back to VBA (Tools >> Customize >> Add Current Window/Report to Visual Basic).
Add the required fields back to VBA (Tools >> Customize >> Add Fields to Visual Basic).
Copy the VBA code back into the appropriate VBA Module.
Compile the Project and Save.
Hope you find this info handy.