1. If I use the switchboard tool to open a form that is a datasheet, and
select the form 'open form for editing' it will open the form but not give
that tabular view. But when I open the form from the project window, or in
code, it will open in the datasheet or tabular view. How can I open a form
in this mode via the switchboard manager.
2. I have a table that has many categories. It is probably best to make
each one of these categories a separate table, but there would be like 60
tables.
So, how can I allow the user to edit these categories. For example, there
is a size, color, shape field. The person cannot just delete a size from
the size column, because it would effect all the other columns etc. is
there a way I can have the user delete this one cell and have everything
from that one column move up one to get rid of the gap. This way no other
columns are affected.
Thanks
Danny