Post reply

User Form with sorted updatable recordset

  • January 12, 2005 at 6:23 am

    #361817

    How can I provide a user with a form containg a sorted updatable recordset. The procedure (or view or function) must use an input parameter. I have an Access front end and SQL Server 2000 backend. The command object seems to only give me non-updatable recordsets. On the other hand, if I open a recordset object directly after setting the cursor abd lock parameters, I can't seem to sort it (TOP 100 PERCENT, etc) and make it updatable. Thank you.

  • January 17, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • January 21, 2005 at 7:52 pm

    #538636

    I have actually been able to solve this problem. I have opened a recordset object (rst) using a user defined function (returns table) and set the form.recordset=rst in the form.load event. It actually works great. The form loads in no time and the recordset is updatable. The trick is to have all the required fields in the user function that sets the form recordset.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply