Hide text fields in subform (1 Viewer)

foxtet

Registered User.
Local time
Today, 20:27
Joined
May 21, 2011
Messages
129
Hi Every one.
I have a tab control TabCtl49 on frmCargo Master.On the TabCtl49 there is a sub form frmInvDetails. This form display as a data sheet.
I want hide ID and InvNo field from this sub form. Even if we hide those fields it should save in tabInvDetails table.

I tried different methods not yet successful. Can any one give me a quick solution for this? for reference db is attached.

foxtet
 

Attachments

  • Invoice.accdb
    1,020 KB · Views: 60

JHB

Have been here a while
Local time
Today, 17:27
Joined
Jun 17, 2012
Messages
7,732
Try the attached:
 

Attachments

  • Invoice.zip
    219.8 KB · Views: 124

MarkK

bit cruncher
Local time
Today, 09:27
Joined
Mar 17, 2004
Messages
8,178
Put the fields you want hidden in the form header in design view.
 

llkhoutx

Registered User.
Local time
Today, 11:27
Joined
Feb 26, 2001
Messages
4,018
Set the "Visible" property on the datasheet columns you with to hide to False or No. Visible, or not, those controls will be saved appropriately.
 

JHB

Have been here a while
Local time
Today, 17:27
Joined
Jun 17, 2012
Messages
7,732
Hmm - by me it is, see attached pictures.
Could you please clarify?
 

Attachments

  • tblinvDetails before.jpg
    tblinvDetails before.jpg
    65.9 KB · Views: 207
  • tblinvDetails after.jpg
    tblinvDetails after.jpg
    94.8 KB · Views: 126

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 00:27
Joined
May 7, 2009
Messages
19,169
In your subforms Load Event:

Me.ID.ColumnHidden = True
Me.InvNo.ColumnHiddent=True
 

Users who are viewing this thread

Top Bottom