I want the New dialog box to be modal, and the new document that's being created isn't. It's illegal to show a non-modal form while a modal form is being displayed. How can I get around this?

Help your users by adding an easy-to-implement search control to your Access forms.

Need to add a calculated field to an Access form? It's easy, and you can do it on the fly. Just add a new text box control with the appropriate formula as its control source.