Results 1 to 3 of 3
  1. #1
    Shaun is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Jun 2016
    Posts
    2

    Form controls

    Hi

    I want to have a form that has two drop down combo boxes which are referencing tables

    Once an option has been selected in each box I would like a button that will then take this data and open my main form displaying the data selected. Also on the main form I wish to display both selections from the combo boxes.

    If someone could provide help in this I would be very grateful

    Many thanks

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Make a query that looks at the 2 combos as criteria...
    select * from table where [field1] = forms!frmMain!cbo1 and [field2] = forms!frmMain!cbo2

    then just open the query,
    docmd.openQuery "qsMyQry"

  3. #3
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Quote Originally Posted by Shaun View Post
    Hi

    I want to have a form that has two drop down combo boxes which are referencing tables

    Once an option has been selected in each box I would like a button that will then take this data and open my main form displaying the data selected.
    I am confused.
    You want two combo boxes to be able to select two fields, one field from each table, and display the data on a form?

    Or do you have a form with a query as the form record source and you want to filter the record set by the two combo boxes?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 11
    Last Post: 04-09-2016, 08:54 PM
  2. Replies: 8
    Last Post: 01-13-2015, 12:23 PM
  3. Using Tab controls within a form
    By crowegreg in forum Forms
    Replies: 2
    Last Post: 08-25-2011, 08:17 PM
  4. form Controls
    By dref in forum Forms
    Replies: 2
    Last Post: 07-22-2011, 03:31 PM
  5. Controls within form
    By crowegreg in forum Forms
    Replies: 4
    Last Post: 05-31-2011, 08:39 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums