Search results

Hi Rich & Cogent Thanks for ur advice. I think it is working fine when i call this proc in form_error event.First i forgot to set Tag for controls. The loop has to check all the controls evrytime(including non validate).It is ok. Not my problem. Thanks for ur timely help. Reagards Murali...

Hi Rich Thanks for a module level code. Problem is when i have to call this. If a control is bound to a table in database, database fires the event as soon as u try to leave the field blank.(once u started typing). If u have a subform with a database field required and if it is combo which...

Trap error-Reply Hi Cogent, Thanks for the reply. 1. All field in the table are used in form. 2. We cannot trap by writing a code in VBA either in on_exit or lost_focus because database error fires before our vba events. database display an error message what a programmer can understand...

Hi There, I am facing a small difficulty when i am dealing with access database from an access form. I have 'Field' in a table whose required pr. is true. A table is linked to the form as source when i enter nothing in that required field field and try to save, it is throwing an error...

Hi There, I am facing a small difficulty when i am dealing with access database from an access form. I have 'Field' in a table whose required pr. is true. A table is linked to the form as source when i enter nothing in that required field field and try to save, it is throwing an error...