Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003

    Unanswered: Change Recordset(dynamic)

    i have un form with one subform.
    datasheet view both
    i want to change(dynamic) the recordset for subdatasheet when i expand, for every row from form master i want subdatasheet with recorset different

    P.S. I don't know very well enghish, but i think you understand what i say and you help me...

  2. #2
    Join Date
    Nov 2002
    How about trying an after update event? Set it up to trigger when a value has changed to redefine the recordset. Or if I understand correctly, you have 2 datasheet forms (1 on the form and 1 on the sub), correct? I have used the on click event to also trigger this "requery" of the recordset. Your SQL statement would reference a unique field on the datasheet and populate the sub-datasheet with the appropriate record(s). Hope this gets you started. If this isn't quite what you need, explain a little more about what you're trying to do

Posting Permissions

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