Is there a way to make a Datasheet View form "Modal" 2

[GoinDeep]

I have a form that has it's properties set to "Pop-up Yes and "Modal Yes", and Border Style "Dialog". Yet it still allows you to access other forms while this form is open. I am sure it's because the Form View is set to "Datasheet", but that is the way I really want it. I was hoping there was a way around this with out me having to design the form all over again.

Probably not, but I thought I'd see.

 

[lameid]

What if you use the following to open it?

docmd.OpenForm "FormName",acFormDS,,,,acDialog

I'm afraid that is the only idea I have, and probably won't work.

 

[GoinDeep]

Actually that works. I just have to make sure I open the form from code...ie...a macro on the switch board or a command from another form. I hadn't even tried that.

It wont work when I open it from the database window. Unless there is a property setting or step that I am missing.

Thanks a bunch.