DataEntry = True

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What am I missing? Is it the subform syntax? The results arre the same true
or false.

This works!
Me![Securityfrm].Form.DataEntry = False

This does not!
Me![Jobfrm].Form![BCfrm].Form.DataEntry = False
 
In
Chris said:
What am I missing? Is it the subform syntax? The results arre the
same true or false.

This works!
Me![Securityfrm].Form.DataEntry = False

This does not!
Me![Jobfrm].Form![BCfrm].Form.DataEntry = False
Click to expand...

The second statement implies that there is a subform control named
"BCfrm" on the form that is displayed in a subform control named
"Jobfrm" that is on the form that is running this code. If those
premises are all true, I don't see problem. Do you get an error
message? What exactly is happening?
 
Doh! What was I thinking? Here it is.

#2455 for an invalid reference, failing (or hilighting) that non-working line.
--
Thanks for your help,
Chris


Dirk Goldgar said:
In
Chris said:
What am I missing? Is it the subform syntax? The results arre the
same true or false.

This works!
Me![Securityfrm].Form.DataEntry = False

This does not!
Me![Jobfrm].Form![BCfrm].Form.DataEntry = False
Click to expand...

The second statement implies that there is a subform control named
"BCfrm" on the form that is displayed in a subform control named
"Jobfrm" that is on the form that is running this code. If those
premises are all true, I don't see problem. Do you get an error
message? What exactly is happening?

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)
Click to expand...
 
In
Chris said:
Doh! What was I thinking? Here it is.

#2455 for an invalid reference, failing (or hilighting) that
non-working line.
Click to expand...

That error message should have told you the name of the property to
which you were invalidly referring. What was it?

If the erring property was "DataEntry", then check the Source Object
property of the BCfrm subform control. Make sure that it's a form, and
not a table. (Although a quick test seems to suggest that this should
work even for a table datasheet.)

If the erring property was "Form", make sure that BCfrm is in fact a
subform control.

If the erring property was "BCfrm", make sure that the subform control
is actually named "BCfrm", and not "Child0" or something like that.
 
Thanks, Dirk.

The offender is "field" BCfrm. The subform is so named and is a form.

Does this help?
 
In
Chris said:
Thanks, Dirk.

The offender is "field" BCfrm. The subform is so named and is a form.

Does this help?
Click to expand...

Mystifies more than helps, but let's go with it. Is BCfrm on the
subform Jobfrm, or is it on the main form?
 
In
Chris said:
It is a subform of the main form's subform [Jobfrm].
Click to expand...

Chris, I'm baffled. I can't help thinking it must be something that
would be obvious if I could see your database and poke around in it a
little. If you'd like to send me a cut-down copy of your database,
containing only the elements necessary to demonstrate the problem,
compacted and then zipped to less than 1MB in size (preferably much
smaller) -- I'll have a look at it, time permitting. You can send it
to the address derived by removing NO SPAM and ".invalid" from the reply
address of this message. If that address isn't visible to you, you can
get my address from my web site, which is listed in my sig. Do *not*
post my real address in the newsgroup -- I don't want to be buried in
spam and viruses.
 
Thanks for the offer, Dirk.

I have 1-2 other issues that defy newsgroup help and I am certain it is
something I have done to preclude resolution.

As this db is in development, as is my training, I will hunker down and
figure it out. Thanks to the newsgroup, I have learned better methods so I
am going in for a fairly major rewrite of code -- to grossly simply and
eliminate duplication. It has been a learning-build. Back to the (almost)
blank sheet!

--
Thanks for your help,
Chris


Dirk Goldgar said:
In
Chris said:
It is a subform of the main form's subform [Jobfrm].
Click to expand...

Chris, I'm baffled. I can't help thinking it must be something that
would be obvious if I could see your database and poke around in it a
little. If you'd like to send me a cut-down copy of your database,
containing only the elements necessary to demonstrate the problem,
compacted and then zipped to less than 1MB in size (preferably much
smaller) -- I'll have a look at it, time permitting. You can send it
to the address derived by removing NO SPAM and ".invalid" from the reply
address of this message. If that address isn't visible to you, you can
get my address from my web site, which is listed in my sig. Do *not*
post my real address in the newsgroup -- I don't want to be buried in
spam and viruses.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)
Click to expand...
 
Back
Top