show field depending on checkbox

So use

Forms!MyOtherForm!MyTextbox.Visible = Me.MyCheckbox

or

Forms!MyOtherForm.SubForm.Form!MyTextbox.Visible = Me.MyCheckbox

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"VB" wrote in message
...
O. and one more thing. it's not Me. it's another form! there is one form
with
checkboxes and another one (maybe subform) with textboxes (or datasheet).

"Douglas J. Steele" wrote:

In the AfterUpdate of each of the 35 checkboxes, you'd need code like:

Me.MyTextbox.Visible = Me.MyCheckbox

to have MyTextbox be visible if MyCheckbox is checked (and not visible if
MyCheckbox is unchecked)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"VB" wrote in message
...
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)?

help please

if another form is closed I get err Msg. if it's closed, columnes are not
hiding!

"Ofer" wrote:

To hide a field in another form

Forms![Form Name]![FieldName].ColumnHidden = True

In a SubForm

Forms![Form Name]![Sub Form NAme].Form![FieldName].ColumnHidden = True

--
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


"VB" wrote:

O. and one more thing. it's not Me. it's another form! there is one form with
checkboxes and another one (maybe subform) with textboxes (or datasheet).

"Douglas J. Steele" wrote:

In the AfterUpdate of each of the 35 checkboxes, you'd need code like:

Me.MyTextbox.Visible = Me.MyCheckbox

to have MyTextbox be visible if MyCheckbox is checked (and not visible if
MyCheckbox is unchecked)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"VB" wrote in message
...
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)?

help please

You can set the fields ColumnHidden on the load event of the form.


--
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


"VB" wrote:

if another form is closed I get err Msg. if it's closed, columnes are not
hiding!

"Ofer" wrote:

To hide a field in another form

Forms![Form Name]![FieldName].ColumnHidden = True

In a SubForm

Forms![Form Name]![Sub Form NAme].Form![FieldName].ColumnHidden = True

--
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


"VB" wrote:

O. and one more thing. it's not Me. it's another form! there is one form with
checkboxes and another one (maybe subform) with textboxes (or datasheet).

"Douglas J. Steele" wrote:

In the AfterUpdate of each of the 35 checkboxes, you'd need code like:

Me.MyTextbox.Visible = Me.MyCheckbox

to have MyTextbox be visible if MyCheckbox is checked (and not visible if
MyCheckbox is unchecked)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"VB" wrote in message
...
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)?

help please