Hiding Columns in Datasheet View Subform

[Spartacus]

Hello!

The problem at hand for me is to be able to hide columns in the datasheet view of a subform wherever "#Name?" appears (see attachment). For reasons I cannot control, the reason the error "#Name?" appears is because the recordsets (in this case Oct. 2005 onward) do not yet exist - for example, when the Oct-05 data is entered the 2005-04 (or 2005-Q4) recordset will populate. In the meantime, I wish I could find a way to hide it from users until such date's populated.

My VBA experience is very minimal, 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.

 

[seth_belgium]

If possible, upload your database and I'll take a look.

Greetz,

Seth

 

[modest]

You can fix the #Name? error, or even fix what is displayed by editing your query. To do this dynamically, you will need some VBA. Otherwise, I suggest just putting a Nz() or possibly IIF() around whatever is causing the problem and let it remain blank.

Post your query for help on this.