Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002
    Posts
    395

    Unanswered: Re: subform's recordset is not updatable. PLEASE HELP!

    Urgent Help!
    > My subform's recordset is not updatable.
    > The property setting are
    > recordsource: view
    > fileter: field <> 0
    > order by: cust_name
    >
    The subform is not link to the main form.
    The main form contains buttons to change the subform setting to allow user
    to enter shipping quantities, dates, etc, and there new work order fields
    where user enters the work order and enters into tblshipping schedule. .

    When the subform opens it display the filter records of the tblshipping
    schedule. That's fine.
    The subform's recordsource in set in Access form property point to a view.
    The view is a filtered tblshipping schedule.
    But tried to edit the subform by changing the quanity field. The recordset
    is not updatable message display in Access.

    I'm using Acc2K and SQL Server as BE.

    I really appreciate any help or suggestions

  2. #2
    Join Date
    Nov 2003
    Posts
    1,487
    Posting this problem ONCE is usually enough.



Posting Permissions

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