Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    NJ, USA
    Posts
    617
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Form and query not accepting data (Access Sp)

    I just used the second join on the query and that allowed all data to be displayed. But now the form and query does not accept data input. I would appreciate any and all help and ideas. Thank you.
    Fay

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Form and query not accepting data (Access Sp)

    Multi-table queries are not necessarily updateable, especially with referential integrity enabled. You have to be careful how you build them. The most usual way to handle this is to base the form on one or two tables and use a subform based on the third table.
    Charlotte

Posting Permissions

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