Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Jul 2002
    Posts
    58
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Forms/Subforms (Access 2002)

    I do not understand why my second subform will not allow me to add price to it. I have read and looked at John's Hutchison examples but I am stumped.
    Why is the field not updataable?
    Thanks
    Rbelly
    Attached Files Attached Files

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Forms/Subforms (Access 2002)

    Do you want to convert the database back to A2000 for the rest of us to look at.
    As always, John will probably log in and tell you the answer before we get a chance, but that's the nature of this forum and one which makes it so great.
    Pat <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  3. #3
    Star Lounger
    Join Date
    Jul 2002
    Posts
    58
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Forms/Subforms (Access 2002)

    I think it is already in Access 2000 format. I have not changed the default when I created it.

    Rbelly

  4. #4
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Forms/Subforms (Access 2002)

    The problem is that vendorID in the prices subform is bound to VendorID in the Vendor table, rather than Vendorid in the prices table.
    Regards
    John



  5. #5
    Star Lounger
    Join Date
    Jul 2002
    Posts
    58
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Forms/Subforms (Access 2002)

    Thanks John,

    Now I understand! Well now to the next part and when I get stuck I will holler.
    <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>

Posting Permissions

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