Customising datasheet in a subform

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating Top 10 in linked subform 1
can Find record combo be bound?? 2
Choice in combo box determines other field 1
results returned to appear in a combo box 2
Need a button to update a table 6
Copy date from a form to a different table 10
Displaying a simple message box 1
Unremovable horizontal scroll bar on subform 1

Back
Top