Set form dirty through unbound control

[twinkler]

Dear all,

I have an unbound listbox (multiselect) on a bound form.
The listbox and its selection are populated via vba from a table.

I have an invisible helper txt field which is bound to a table.

The helper txt receives whatever is selected in the listbox by setting
its value property to the list box elements.

Unfortunately this does not make the form dirty. Apparently changing
the value property of a txt field does not trigger the dirty event but
only changing the text property of a text field does.

I can not set the text value of my little helper txt field because it
has to have focus and for getting focus it has to be visible.

Is there a way to make the form dirty via VBA from the listbox? Can I
somehow trigger the event?

I tried to set the text property of a visible bound text field
( Me.txtAlias.Text = Me.txtAlias.Text ) but I am getting a run time
error 2115 - macro or function set to beforeupdate or validation rule
is preventing the application from saving data into the field. Even
though I positively to not have beforeUpdate of Validation rules on
txtAlias...

Any help is appreciated

Cheers

Torsten

 

[Marshall Barton]

I have an unbound listbox (multiselect) on a bound form.
The listbox and its selection are populated via vba from a table.

I have an invisible helper txt field which is bound to a table.

The helper txt receives whatever is selected in the listbox by setting
its value property to the list box elements.

Unfortunately this does not make the form dirty. Apparently changing
the value property of a txt field does not trigger the dirty event but
only changing the text property of a text field does.

I can not set the text value of my little helper txt field because it
has to have focus and for getting focus it has to be visible.

Is there a way to make the form dirty via VBA from the listbox? Can I
somehow trigger the event?

I tried to set the text property of a visible bound text field
( Me.txtAlias.Text = Me.txtAlias.Text ) but I am getting a run time
error 2115 - macro or function set to beforeupdate or validation rule
is preventing the application from saving data into the field. Even
though I positively to not have beforeUpdate of Validation rules on
txtAlias...

Events are not triggered by code stting a control's value.
(The Dirty property will be set though.)

However, that's not a serious issue because you can call any
procedure in your code. To call the Dirty event procedure,
use:
Form_Dirty dummy

 

[twinkler]

Events are not triggered by code stting a control's value.
(The Dirty property will be set though.)

However, that's not a serious issue because you can call any
procedure in your code. To call the Dirty event procedure,
use:
Form_Dirty dummy

Thanks heaps Marsh, your suggestion works!

Cheers

Torsten