Form View

Form View · Mar 9, 2005

Fred,
Thanks. I am using the Access created Switchboard manager.
I put a condition,
If Rs![Argument] = [Formname] Then
DoCmd.OpenForm Rs![Argument], acFormDS
Else
DoCmd.OpenForm Rs![Argument]
End If
and it worked. Is this the way to go?
Also,
When I view the form in datasheet view, Is it possible to
add or change the data?

Jyoti

-----Original Message-----

Regardless of the Form's Default View setting, if you open the form
from an event on another form you must explicitly open in in Datasheet
view.
DoCmd.OpenForm "FormName", acFormDS

If you are using your own custom designed menu, simply change the code
behind to command button.

If you are using the menu created by the Access Switchboard manager,
you have a bit more to do. Post back if you need help with that.

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.

..