A little direction.....please

[jakehale]

Basic user here,, I know I have seen what i am looking for on someone elses database but for the life of me I cant figure it out...

I would like for a field to open upon the click of a check box...

ie...

check box: [attrite], if I check the box I would like the field [date] to open in order for me to put a date in it. if the box is not checked the [date] field will not be seen.

is this simple? if it is code could you really explain on how to do it? Can it be done with a form or something different?

thanks for the help

Jake

 

[ssteinke]

Try this:

In the BeforeUpdate event of the checkbox:

Me.YourFieldName.Visible = Me.YourCheckBox

 

[jakehale]

Thanks

Try this:

In the BeforeUpdate event of the checkbox:

Me.YourFieldName.Visible = Me.YourCheckBox

that worked but the "onclick" worked better for some reason. When I opened the form the [fieldname] was visable, then I clicked and unclicked the field would go away and then come back.

using the onclick,,, it wasnt on my form until i clicked the box.....

thanks

I better start searching for code codes' I still have no clue what the me.[yourfieldname].visable does or where you found it. But you helped and for that I thank you

 

[seth_belgium]

You'd better place it in the AfterUpdate-event instead of the OnClick, it's more accurate.

 

[jakehale]

Will do

OK,, The "coding" is very new to me.... I will try that also

thanks

 

[ssteinke]

Make certain you have your default 'Visible' property set to 'No' for your field and the 'Default Value' property of your checkbox to 'No'. This should accommodate your problem with the field being hidden when the form is first opened.

 

[jakehale]

Like a champ

Make certain you have your default 'Visible' property set to 'No' for your field and the 'Default Value' property of your checkbox to 'No'. This should accommodate your problem with the field being hidden when the form is first opened.

Worked out great! Thanks for the help... I knew I could count on the forum to help me out........