Hide text fields in subform

[foxtet]

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

 

[JHB]

Try the attached:

 

[MarkK]

Put the fields you want hidden in the form header in design view.

 

[llkhoutx]

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.

 

[foxtet]

Try the attached:

InvNo is not saving in tabInvDetails hence when opened related details not display in sub form.

foxtet

 

[JHB]

Hmm - by me it is, see attached pictures.
Could you please clarify?

 

[arnelgp]

In your subforms Load Event:

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