Results 1 to 3 of 3
  1. #1
    Join Date
    May 2008
    Posts
    48

    Unanswered: Query required based on user's choice of field through Form.

    I have MS Access table, in which, there are number of fields. I want to run a query based on user's choice of field, through a Form (Like Option Button).

    Kindly confirm if is their any method to run a query so that user can get the data based on opted field.

  2. #2
    Join Date
    May 2005
    Posts
    1,191
    Me.Geek = True

  3. #3
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    This might spark a few other ideas for running queries "within" a form.

    http://www.dbforums.com/6390529-post84.html

    Otherwise, there are several form criteria examples to do what you want in the code bank.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

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