Prev: Save or Update command
Next: Hyperlink in access 2007 opens with intranet instead of windows vi
From: steve on 14 Apr 2010 23:43
This does not seem to work completly.
Perhaps hard to explain but this form has another form in it, that
displays another table. I can set the settings of the form in the
smaller form as you have described, and indeed I cannot change any
data but can add data. However as soon as I set the 'do not edit' on
the larger fform that contains the smaller form, the ability to add
new records on the smaller form (what I call the sub form),
disapears.

Any advice?
From: Hans Up on 15 Apr 2010 02:47
steve wrote:
> This does not seem to work completly.
> Perhaps hard to explain but this form has another form in it, that
> displays another table. I can set the settings of the form in the
> smaller form as you have described, and indeed I cannot change any
> data but can add data. However as soon as I set the 'do not edit' on
> the larger fform that contains the smaller form, the ability to add
> new records on the smaller form (what I call the sub form),
> disapears.
>
> Any advice?

Maybe don't set 'do not edit' on the parent form so the subform will
behave as you want. Then, for the other controls on the parent form,
set them to Locked = Yes and Enabled = No. Not sure sure if that would
fit your need. And there may a better way ... but I'm not seeing it.
From: steve on 15 Apr 2010 10:15
It seems no matter how I set it this does not work perfectly.
I guess there is no way to set it on an individual field basis in the
form, rather than set it for the whole document?

Regards
From: Hans Up on 15 Apr 2010 11:35
steve wrote:
> It seems no matter how I set it this does not work perfectly.
> I guess there is no way to set it on an individual field basis in the
> form, rather than set it for the whole document?

My form's data source is a query which includes a field named "lname".
On the form is a text box named "txtlname" which is bound to the lname
field. When I change txtlname properties to Enabled = No and Locked =
Yes, I can see the data contained in the lname field ... but I can't get
at it to change the value ... it's sort of like read-only on the form.

What else did you have in mind for "set it on an individual field basis
in the form"?
From: steve on 15 Apr 2010 15:29
I see what your saying, I guess Im just trying to resolve the problem.
For some reason you can make the second form the way I want it but not
the first. I will have to try to do some research and see if I can do
it some other way. Thanks.
First  |  Prev  | 
Pages: 1 2
Prev: Save or Update command
Next: Hyperlink in access 2007 opens with intranet instead of windows vi