G
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
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