Opening Form From Database Object Window vs. Via Switchboard Menu

[Guest]

The form when opened from the database object window shows records that are
stored in its table. When that same form is opened using the switchboard
forms, the form does not show any records. The form's Data Entry property is
set to 'No'. How do I get the records to show when I open the form through
the switchboards?

 

[Larry Linson]

The form when opened from the database object window shows records that
are
stored in its table. When that same form is opened using the switchboard
forms, the form does not show any records. The form's Data Entry property
is
set to 'No'. How do I get the records to show when I open the form
through
the switchboards?

If it's opened via code, what's in the DoCmd.OpenForm can override
properties as set for the Form, so you'd have to look and see what the
DoCmd.OpenForm statement says. As for my part, I build my own Switchboards,
so I know what is going on. If you use the Switchboard Manager, not only do
you not know what it generates, you've chosen a complex solution for a
simple problem... one that involves modifiable Forms, a File, and
non-trivial VBA code.

Larry Linson
Microsoft Access MVP

 

[Guest]

I worked out this problem myself... It turns out that when I designated
controls for the switchboard item to open the form using the Switchboard
Manager, I needed to select the "open form in edit mode" option on the
Command line, Not the "open form in add mode". Thanks Anyway