Results 1 to 2 of 2
  1. #1
    Andra is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Apr 2017
    Posts
    2

    Unhappy Trying to filter a form by using a combobox

    Hi,
    I've been trying to get this right for a while and I've just managed to get more frustrated.


    I have 2 tables which I am trying to work with, basically I need to select a word from the wordtable and I want to filter the form by using the combobox and i want it to return a name from the nametable.
    nametable has a unique identifier and a primary key but the second table does not have a primary key( i did not create the tables,i just have to work with them). I created a relationship between the 2 tables, the join type is one to many.
    I have tried creating a combobox in the form header and also tried filtering by creating a combobox and a subform but I'm getting nowhere.
    I've gone step by step following tutorials but I can't seem to adapt the information to my situation.
    Thank you
    Attached Thumbnails Attached Thumbnails Stopword_tbd.png   corename_tbd.png  

  2. #2
    andy49's Avatar
    andy49 is offline VIP
    Windows 10 Access 2007
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051
    When you say the combobox in the form idea didn't work what exactly do you mean? It often helps to see your wrong "results" to help us.



    Sent from my iPhone using Tapatalk

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

Similar Threads

  1. Replies: 1
    Last Post: 09-06-2011, 01:47 PM
  2. Replies: 29
    Last Post: 08-16-2011, 05:52 PM
  3. Replies: 0
    Last Post: 08-24-2010, 06:38 PM
  4. Replies: 0
    Last Post: 12-16-2009, 01:14 PM
  5. Form Combobox filter
    By westcoastbmx in forum Forms
    Replies: 0
    Last Post: 10-20-2009, 11:27 PM

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