Customising datasheet in a subform

[Guest]

I've got a rable of parts
PartNumber
Description

And a table of manufacturers
PartNumber
Manufacturer
Manufacturers PartNumber

I've got a form showing parts with a subform showing manufacturers as a
datsheet view. All works OK, when I select a part I see a list of
manufacturers with their part numbers in the subform data sheet.
I don't want to see the PartNumber field in the subform. If I right click
the column and hide it I get what I want but the "hide" is not saved - the
column is back when I close / open the form.
If I open the properties / source data and untick show under PartNumber the
form asks me to enter the part number manually when it loads.
How can I hide this column?
Thanks
Alec

 

[Graham R Seach]

Alec,

Open the form in Datasheet view. Either hide the column or shrink it so it's
no longer visible. Then save the form. That should hold.

Regards,
Graham R Seach
Microsoft Access MVP
Canberra, Australia