Text box not reappearing based on an if statement of a tickbox

[j.smith1981]

Hi there,

Thanks ever so much for helping me out requery a form based on the adding of new entries and going back to my main form, its been a real help!!

I am having one slight problem though.

I have a tickbox, that when you check the tickbox, a file_location textbox appears, for the user to enter information, have a conditional macro that says something must be entered into this space when its visible.

But when I close that form, then go back to that same record, the tickbox is ticked now (from the previous question i have put), but the file_location textbox doesnt appear, until I uncheck the tickbox and then retick the textbox appears with the file_location entered into that box.

Is there any means of making it appear every time when the filed tickbox is checked, when I go back through records?

Hope this makes sense and thanks for any advice in advance,
Jeremy.

 

[rainman89]

You can do a check in the oncurrent of the form to see if the checkbox is checked.. if it is, then show the textbox

 

[j.smith1981]

You can do a check in the oncurrent of the form to see if the checkbox is checked.. if it is, then show the textbox

That worked, thought I was going mad!!

Thanks ever so much!

 

[j.smith1981]

That worked, thought I was going mad!!

Thanks ever so much!

Actually I banged the filed boolean tickbox in the same bit aswell and its working better now.

Thanks again,
Jeremy.