hiding fields when displaying tables

[meadt]

Hi Guys,

I think this should be another simple one,

I need to display a table but hide a few of the fields. Im using the code below to open the table, but how would I hide certain fields?

DoCmd.OpenTable "Data Conversion", acViewNormal, acReadOnly

Cheers,

T.

 

[JANR]

Why don't you just make a query with the fields you want to show and open that query instead.

Docmd.OpenQuery "qryYourQuery", acViewNormal, acReadOnly

JR

 

[meadt]

Im not using a query because the table I need to bring up is linked to another and the user needs access to these records (via the drop down) Ive tried creating a relationship with a query and this table, but i loose the ability to expand the records from the other table. Is there not a way of hiding fields in the DoCmd.OpenTable command?

Thanks for your suggestion though!

T.

 

[JANR]

Not to my knowlage, sorry. FYI your metode implies the usage of subdatasheet which is not recomended, beeing incredebly slow and not userfrendly.

Use a form with subform is the best solution for you, I think.

JR

 

[gemma-the-husky]

if you really want to do this, one way is to split the tables into 2 - with a 1 to 1 join. (if you like, a public tabler and a private table)

then your user can see the public table, and not the private table.

Might not be too much work for you.

----------
Better to use the suggestions already offered though, of not using the tables directly.