change subform to full screen

[cacacaconnie]

I have a form (Worksheet) with a subform (Equipment), the subform is a data
sheet for entering equipment for a proposal. I would like to bring the
subform full screen for large jobs and easier viewing but also keep small
working space of this subform on the worksheet that will allow me to scroll
through the equipment items. Can this be done?

 

[Ed Robichaud]

One technique is to have a "summary" datasheet subform (just the highlights
of each record), but include a command button to open a related single
record form to show more/all fields for data entry ease.
-Ed

 

[Damian S]

Hi cacacaconnie...

You could have an on double-click event that opens a form to edit the record
that you double click... That way you could have a small amount of space to
scroll through (in the subform), that opens a larger amount of space to edit
a record.

Hope that helps.

Damian.