Results 1 to 2 of 2
  1. #1
    ridgeandgable is offline Novice
    Windows 10 Access 2007
    Join Date
    Jul 2017
    Posts
    3

    Display Categorys

    Hi Guys

    I have a small table called Customers with the following data



    ID
    Name
    Address
    Town

    I have another table called towns -

    ID
    Town

    I want a form that will allow me to display records from (Towns) and show all records within that town?

    How can I do this?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    In the form , put a combo box,
    set this box to fill from tTowns.
    you can also have a combo filled with states.
    picking a state can then limit the towns in the town combo.

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

Similar Threads

  1. Display First/Last or Max/MIN
    By Thompyt in forum Programming
    Replies: 6
    Last Post: 03-09-2018, 12:50 PM
  2. Replies: 3
    Last Post: 10-28-2015, 12:38 PM
  3. Replies: 2
    Last Post: 06-24-2015, 02:38 PM
  4. Display top 25 %
    By Faisal Mobin in forum Queries
    Replies: 2
    Last Post: 12-01-2012, 05:14 AM
  5. Report control of a field display/no display
    By systems013 in forum Reports
    Replies: 5
    Last Post: 02-01-2010, 09:44 AM

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