Datasheet view of Main Form

  • Thread starter Thread starter Alan Mitchell
  • Start date Start date
A

Alan Mitchell

I have a form and a sub-form.
I want the main form to open in datasheet view and expand
to form view of sub form when the appropriate record is
selected.
I need this to run from the switchboard but the
switchboard insists on opening the main form in form
view. How can I force it to open in datasheet view.
I am a fairly basic user and don't know how to code.
I am running Access 2002.
All suggestions gratefully received.
 
The simple answer is - you cant. A form-subform arrangement relies on
having only one record shown on the main form, so that the subform records
are related just to that one record.

A possible way around is to have two forms showing the main records, one in
datasheet view, and the other, with a subform, single form view. It is
possible to link the two together so that selecting a record in the
datasheet form selects the same record in the other form, and so brings up
the subform records. Check out the form design wizard for linking two forms
together.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Back
Top