How can I hide columns in a query(subform) using input from form?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BlakeFasching - 01 Nov 2005 17:18 GMT

I am creating a custom reporting form to allow a user to select (using
checkboxes) which fields they would like to see or hide in the resulting
subform which is populated by a query. I tried setting the
subform.field.visible property to false, but when looking at the data in a
datasheet view the column is still visible.

Any help is much appreciated.

Thanks
Blake

Reply to this Message

Ofer - 01 Nov 2005 17:28 GMT

Try this

Me.SubFormName.Form.FieldName.ColumnHidden = True

Signature

If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck

> I am creating a custom reporting form to allow a user to select (using
> checkboxes) which fields they would like to see or hide in the resulting
[quoted text clipped - 6 lines]
> Thanks
> Blake

Reply to this Message