subform text box.visible = false doesn't work

[rust]

Hi All,
I have a sub form with text boxes that I don't want the user to see or fill it, but I will from the information on the main form.
In design mode I set visible = false and they still showed.
I then did it code with the visible and enabled property = false and tab stop = no. The boxes aren't enabled but they still are visible !!!!

 

[RealKiwi]

If you want to control their appearance from the main form, try:

Forms!SubformNameHere.form.TextBoxNameHere.Visible = False

RK

 

[rust]

Thanks for the suggestion,
I got so frustrated I took them off and ran a query on the form_afterupdate event.
I thought I could do it on the field after_update event for a newly inserted row. (the one that was part of the where clause) but no rows were updated cause the value wasn't on the table yet cause it was an insert.

The main idea was to keep them invisible and as the user tabbed across the visible sub form fields the invisible ones would be filled in. But I wanted them invisible from the start so while designing and testing I could put the visible ones on top of the invisible ones - didn't work out.


I will try your idea on one of the later forms.