How to disable subforms until a field is enterered?

  • Thread starter Thread starter TK
  • Start date Start date
T

TK

What is the best way to prevent the focus from moving to a
subform until a particular field on the main form has been
entered?

Any thoughts appreciated.


TK
 
* Set the Enabled Property of the Subform*CONTROL* to
False; or

* Set the Subform*CONTROL* to invisible until the
(TextBox?) Control data has been entered.

Use the Control_AfterUpdate Event to enable the
SubformCONTROL or to make the SubformCONTROL visible.

HTH
Van T. Dinh
MVP (Access)
 
Thanks,

That is exactly what I needed, and is much more elegant
than what I had been doing, which was using the OnDirty
event of the subform to check if the required value had
been entered on the main form, (and cancelling the subform
entry if not so).

Cheers!

TK
 
Back
Top