Results 1 to 11 of 11
  1. #1
    Join Date
    Apr 2004
    Posts
    77

    Unanswered: How to edit a subform !

    Hi there

    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

  2. #2
    Join Date
    Oct 2003
    Posts
    81
    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.

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Question

    If you mean Edit it in the desigen mode, then double click the Subform in the desigen mod.

  4. #4
    Join Date
    Apr 2004
    Posts
    77

    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
    me.allowedits= true
    firstname.setfocus
    end sub

    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?

  5. #5
    Join Date
    Apr 2004
    Posts
    77
    can someone pls tell me how to check tables persmission for a form ? Pls

  6. #6
    Join Date
    Oct 2003
    Posts
    81
    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.

  7. #7
    Join Date
    Apr 2004
    Posts
    77

    re subform edit

    Thanks for the reply. 3.14. I would apply this suggestion

  8. #8
    Join Date
    Jul 2004
    Posts
    30
    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.

  9. #9
    Join Date
    Apr 2004
    Posts
    77

    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.

  10. #10
    Join Date
    Jun 2002
    Location
    Saudi Arabia / Philippines
    Posts
    126
    Hi CD

    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.

  11. #11
    Join Date
    Apr 2004
    Posts
    77

    Smile re:how to edit subform!

    Hi Rod

    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.

    Many Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •