Controls on sub-form

  • Thread starter Thread starter J. Shrimps Jr.
  • Start date Start date
J

J. Shrimps Jr.

If a certain condition is met, I would
like certain controls on a sub-form disabled,
so there isn't any chance of accidental entry
of data in the wrong controls.
Me.subEntry1.form!data.enabled = false
This works for all the controls EXCEPT for the
last five (there's about 30 total)
Get an error message saying "database can not find
the field 'txtCompletedate'
 
--This is the complete post without hitting the send
button prematurely---
If a certain condition is met, I would
like certain controls on a sub-form disabled,
so there isn't any chance of accidental entry
of data in the wrong controls example:
'Me.subEntry1.form!data.enabled = false'
This works for all the controls on the subform EXCEPT for
the last five (there's about 30 on the subform).
when the focus moves to the subform, get an error message
saying "database can not find
the field 'txtCompletedate' in your expression"
even though it is on the subform (that's two other
subforms and over 100 controls total - including all
subforms on the form).
I'm thinking that Access has but so much memory to refresh
the screen and when it reaches these last five controls
to refresh, it just says they're not there.
 
Back
Top