+ Reply to Thread
Results 1 to 2 of 2

Search form to show a list

  1. #1
    Registered User
    Join Date
    11-17-2015
    Location
    Nitra, Slovakia
    MS-Off Ver
    Office 2013
    Posts
    66

    Search form to show a list

    Hi everyone,

    So I've started to use MS Access for database logging, I've managed to make a simple form to store a person's name, grade & training (with dates and status) now I'm trying to find how to make a search form that a user would be able to choose a name from the database (only ones that were already added) and then the search form would show what trainings the user has had, on what day and what is the status.

    Is this possible to be done in base of access or is VBA required?

    Thank you
    Last edited by Martines91; 02-25-2020 at 02:06 PM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    18,260

    Re: Search form to show a list

    You would do this building a query using the table that is bound to the form as the record source.

    https://edu.gcfglobal.org/en/access2...imple-query/1/

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Search output in list form using Excel spreadsheet
    By ghargenilesh in forum Excel General
    Replies: 1
    Last Post: 05-07-2018, 04:37 PM
  2. Delete range based on form search list
    By terriertrip in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-07-2016, 11:53 AM
  3. Search Folder and Show Results in Userform List Box
    By powerplug in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-14-2016, 05:18 AM
  4. Search range for a list of strings, show userform and replace selected cells.
    By banaanas in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-24-2015, 01:04 AM
  5. [SOLVED] Search for values, create a list and show in message box
    By gokica in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-20-2015, 08:40 PM
  6. How to show/hide/unload form when form name is a string variable?
    By achmidt in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-13-2012, 06:21 PM
  7. Drop Down List in form shows numeric value in database-want to show actual value
    By DonutMonster in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-05-2009, 09:32 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1