show query result depending on checkbox

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

VB - 06 Nov 2005 16:51 GMT

I have a query with 35 fields. on the form I'd like to create 35 checkboxes.
user may check or uncheck them depending on he fields thay want to see. is it
possible? how to pass checkboxes true/fals to query? or how to hide
unnecessary columnes on the form (datasheet)? textboxes won't rearange :(

help please

Reply to this Message

Ofer - 06 Nov 2005 17:05 GMT

Try this to hide the column in a datasheet view

Me.FieldName.ColumnHidden = True

Signature

The next line is only relevant to Microsoft''s web-based interface users.
If I answered your question, please mark it as an answer. It''s useful to
know that my answer was helpful
HTH, good luck

> I have a query with 35 fields. on the form I'd like to create 35 checkboxes.
> user may check or uncheck them depending on he fields thay want to see. is it
> possible? how to pass checkboxes true/fals to query? or how to hide
> unnecessary columnes on the form (datasheet)? textboxes won't rearange :(
>
> help please

Reply to this Message