ranjan,
From the Access Help file:
"You can use the Modal property to specify whether a form opens as a modal
form. When a form opens as a modal form, you must close the form before you
can move the focus to another object. Read/write Boolean."
Also:
"When you open a modal form, other windows in Microsoft Access are disabled
until you close the form (although you can switch to windows in other
applications). To disable menus and toolbars in addition to other windows,
set both the form's Modal and PopUp properties to Yes."
To read the entire info about this topic, and to get help on many aspects of
using Access, try opening a form in design mode and display the Properties
dialog box. Then locate the "Model" property, place your cursor in that
property and press the F1 (Help Key) on your keyboard. The entire help topic
for "Model" will be displayed. You can also check out the "Popup" mode for a
form.
I don't want it to seem that I did not want to just answer you question, but
I did want to convey that the Access Help file does have a great deal of help
and can explain many topics better that we can recreate the explanation. I
would suggest that anyone first try searching the Help file, and even these
newsgroups for answers that may already be available.
