var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to edit a subform !
I have a form that contains a subform , both are linked by the common ID. I have designer the form so that the user can edit the data.
However when I tried testing the form.... I notice that I can only edit the upper part of the form and not the lower part (which is the subform.)
Pls does anyone know how I can get round editing boths. or is this an impossible thing.?
Many Thanks in Advance
Check your table permissions. Sometimes you may have a permission on the master table but not on the table for the subform.
One possibility anyway.
If you mean Edit it in the desigen mode, then double click the Subform in the desigen mod.
How to edit a subform!
Thanks guys for ur replys.
I would try the table suggestion
Sorry what I meant is users would use this form to edit suppliers details.
Eg a supplier changes address etc.
Th subform then contains the product details of the supplier. ( a price) could also change.
This form is purely for editing only.
I first set the form to edit "no"
I then have an edit button put on the form that allow me edit the form the
code on the button is
private sub editrecord_click
and on the update and and form-current
me.allowedits = false.
However when I click edit button , I can't still edit the subform.
Any More suggestion pls?
can someone pls tell me how to check tables persmission for a form ? Pls
Can the administrator change details on the form? If so, then yes, it is most likely a table permission thingie.
OK... go to:
Tools --> Security --> User and Group Permissions...
In there you will find all the users and groups and all the tables, reports, forms etc they have read, write, edit and delete access for.
Simply find the user that can't edit the subform, find out the datasource for your subform (ie which table) and give them read, write and anything else you want them to have.
re subform edit
Thanks for the reply. 3.14. I would apply this suggestion
Rightclick on the sub form, click "Design in New Window"
This will only work if it is a subform, if it is a subdatasheet in a window then you will need to edit the format of the datasheet or table.
How to let users edit a subform of a form.
Thanks guys for ur replies. I have tried all of the suggestions so far but none of this works so far. If I click the edit button, I can still only edit the main top form.
One thing my thread might not have seem clear about is I want the users to be able to make the changes when necessary (now I am testing the form I noticed the problem).
So basically I give the db to the users , if they need to make changes, on that form , also be able to make changes to the subform.
The tools-security -permission did not work
any more suggestions pls?
Many Thanks for ur help in advance.
You don't say where your edit button is. If it is on the main/parent form then the statement me.allowedits = true will only set the permission for the main/parent form. If it's on the sub form then I cannot see why it does not work.
If you want your button on the main/parent form then you should use a statement something like Forms("mysubformname").allowedits = true
You can probably also do this using the object property of the main/parent form control that 'holds' the sub form.
re:how to edit subform!
Thanks for ur reply to my message.
I did not reliase I needed another button.
I have made the suggestions and it works fine now.