Re-initializing forms

[hbrems]

Hello,

I have created a pop up window where I can select which columns are hidden on a datasheet on my main form.

This pop up window will write the selected settings to a table when closed.

I would also like that the main form re-initializes so that the changes are visible instantly.

When I close the form and re-open it the changes are visible but I would like a more straightforward approach.

Any ideas?

Kind regards,
Hans B.

 

[KeithG]

Maybe try the repaint method of the form

forms!frmName.form.repaint

 

[hbrems]

Nope, it ain't working. Columns are still visible...

 

[KeithG]

do yu have code on the opne event to hide the columns?

 

[gemma-the-husky]

if you are using a datasheet view, i think you will still see notionally hidden columns

you probably need to use a continuous form view to hide fields.

 

[hbrems]

do yu have code on the opne event to hide the columns?

Yes I do. In the attachement a screenshot of how it looks. Please note I want to keep the main window opened.

 

[OlcayM]

This is because you are using datasheet view. If you use form view it will be refreshed immideately. In datasheet view, you should try the columnwidth property by assigning 0. On the other hand, then you have to know the column widths or just assign any width to that column.

HTS
Olcaym