You must enter a value in the 'table_name.control_name' field.

[sophannaly]

Hi,

I use continuous form which bound to table as my user interface. Table primary key is the combination of 3 attributs, for example, A, B and C column. During form input, when user click on new record and input new information but he didn't fill primary key yet but leave focus from that new record, then access will pop up message "You must enter a value in the '.....' field.

This message for user interface is very annoying, how can I solve this like not showing this message but highlight on control border to red instead.

Could anybody point me out how to solve this?

Best regards,
Sophanna

[NeoPa]

Call the .Undo() procedure of the bound form to discard changes. This is equivalent to hitting the <ESC> key.

[sophannaly]

Hi NeoPa,

Thanks for your reply. If I use .Undo(), does it means that when user leave focus from that record, then all its value will erase from form?

Best regards,
Sophanna

[NeoPa]

It means that, before they even leave the record, all changes are lost from the record.

NB. It is the .Undo() of the form only. Control.Undo() only cancels updates to the specific control.

[sophannaly]

Hi NeoPa,

Now I came up with one solution by using form error event and catch this error. And I think it works fine.