Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Feb 2004
    Location
    Moundridge, Kansas, USA
    Posts
    342
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Entering Data in Subform (Access 2003/SP 1)

    I have a stripped down version of a database I am working on and have run into trouble that has me stumped. I can enter a customer's address in the main form, but the subform seems to be off limits. Yesterday it was working. I was toying with some calculated expressions today and I must have messed something up and I can't figure out why I can't enter data in the subform. Any ideas? I can enter data in the table but not in the form.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Entering Data in Subform (Access 2003/SP 1)

    The data source of the subform is a totals query. Totals queries are NEVER updatable, since they aggregate data. Open the query qryUSAOrder Details in design view and turn off Totals, then save it.

  3. #3
    3 Star Lounger
    Join Date
    Feb 2004
    Location
    Moundridge, Kansas, USA
    Posts
    342
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Entering Data in Subform (Access 2003/SP 1)

    That did it! Thanks for the help!

Posting Permissions

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