I,m stuck at mom on the best way to achieve this.
Basically i have 2 modes in my prog,Auto &manual.
Auto is pc generated,manual allows me to insert and calculate using some different data.
I need to be able to switch the view on the current form(subform) so that when I go to manual mode ,the form will display the required "manual" fields in view.
Copying the form will lose (probably) all its relationships/macro/vb attachments,so iam looking for a way to just change the fields (some) on view
Any ideas welcome
Tks

Two ways I can think of

a) have 2 different subforms on 2 different tab controls and use auto/manual to select the tabform
b) have 'hidden' fields that will become visible if manual mode is selected.
or
if the fields are the same, in Auto mode, have the properties set to Locked and Not-Enabled but in manual mode Not-locked and enabled.

HTH

Fizzio!!
Many tks.
Item "b" hidden fields is an interesting idea.
I will experiment around with that and see how it goes.
(The fields in the table are the same in both modes auto/manual..it s just i need to bring in to view the fields with manual data,which are not needed in auto mode.In other words i can get 2 answers from the same table,by just applying different data criteria.)

Hope thats clear