Results 1 to 4 of 4

Thread: form in a form

  1. #1
    Join Date
    Apr 2004
    Location
    ny, ny
    Posts
    224

    Unanswered: form in a form

    I have a form which asks for a start date and end date and then i have a button called show sales
    I have a querry which generates the sales between those dates and then i have
    I need to do the following .. I need to include the querry in datasheet view in my form , when i click on show sales button on my form it should run the querry and display the results in the datasheet view

    thank you

  2. #2
    Join Date
    Apr 2004
    Location
    South Arica
    Posts
    125
    create a subform with the required fields. you can set it's visible property to false. Then when the button is clicked, change the recordsource/filter property of the subform, and make it visible.

  3. #3
    Join Date
    Apr 2004
    Location
    ny, ny
    Posts
    224

    subform

    i dont know how to be able to click the button and update the subform from the querry

  4. #4
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    To update the subform use its RecordSource property

Posting Permissions

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