Record source problem

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi



I Saved As... a form to another name and change the new forms data source.
The problem is that the new form does not show any data with the new data
source. I have tried compact & repair and decompiling but no luck.
Eventually I had to put in the form load event the command
DoCmd.RunCommand (acCmdRemoveFilterSort) to make the form show any data. Why
would the form have a filter attached to it so stubbornly?



Thanks



Regards
 
Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect

Open the form in design view, and delete anything beside the Filter or Order
By properties (in the Properties box.)

Compact the database:
Tools | Database Utilities | Compact/Repair
 
Back
Top