Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2002
    Posts
    23

    Talking Unanswered: query with results in a form

    Hi all,

    I have a form with various command buttons to run queries. Could I see the results of the query appear in another part of the form or on a completely new form and not on a datasheet.

    Thanks,
    Johnny

  2. #2
    Join Date
    Oct 2001
    Location
    Chicago
    Posts
    440
    Use a subform and change the souce object to a form designed around your query.

    Have your current button change the source object of the subform and then requery the subform to display the correct results.

  3. #3
    Join Date
    Oct 2002
    Location
    Sao Paulo - Brazil
    Posts
    16
    Hi MountJohnny,

    If you want only a little preview of de query, you can use also a listbox. Like the subform, the button change de rowsource of listbox for the query and then requery the control.
    Regards,

    Rogerio

Posting Permissions

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