Hiding Columns realtime in Subform

[Spartacus]

Hello!

The problem at hand for me is to be able to hide columns in a subform wherever "#Name?" appears. My VBA experience is minimal to non-existent, but if a not so complex sample code exists out there then I'd appreciate any suggestions you may have.

I have attached a print screen document that shows the result of a query in the subform I just talked about. My anticipated thanks for your help.

 

[llkhoutx]

"#Name?" indicates that the field has an invalid/nonexistent recordsource. If this is your true situation, you have use DAO or ADO code to cycle through the table's fields and is the field does not exist, set the subform column's "visible" property to false.