I used MS Access 2007 to create a continuous form with the Allow Additions Property set to Yes. The user selects from a combo box and uses the After Update Properties of it and a "Find As U Type" text box, to filter the form. However, after an entry in the text box returns no records, I don't know another way to have the records (preferably All Records) reappear in the form without using Allow Additions.

One of my forms has controls with calculated values, so not only is the visible New (empty) Row unattractive, it also has #ERROR Messages in some of its fields. Since these are supposed to be read only forms, I also had to set the Allow Edits to Yes and then include an [Event Procedure] in the Before Insert Property to keep it read only and I was wondering if there is a similar workaround for my Allow Additions property but I just can't see it (maybe I've been staring at it too long!)

The "Find As U Type" combo and text boxes are from a cheater module I found on the following website. There is actually a lot of very helpful, versatile, free code provided for MS Access, I wish I had found it sooner!

http://allenbrowne.com/AppFindAsUTypeCode.html

Any suggestions would be greatly appreciated!