Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Go to retrieved record from search result

Discussion in 'Information Technology' started by lindsay_105, Jul 28, 2006.

  1. lindsay_105

    lindsay_105
    Expand Collapse
    Guest

    Hi,

    I am new to Access and creating databases though I have a background in
    computer animation and have in the past been able to pick up Microsoft
    applications relatively fast (for a non-techie!). However, I need to create
    an image catalog database for a museum. So far, I have created the tables,
    forms and reports, as well as the main switchboard.

    Now I would like to add a search command to my switchboard which would allow
    the user to search for a record based on the fields in my main table. I am
    using the catalogue # of the item as the primary key and would also like to
    be able to search via some of the other fields (such as object name, etc). I
    was able to create a search form using the form from:
    http://www.mvps.org/access/forms/frm0045.htm

    This search form fits my needs, with the exception of using all my tables
    and all their fields as search categories (which ideally I would like to pick
    and choose these). My main issue however, is that when the search results
    come up -- is it possible to click on a record and create a button or event
    to open up the form with that specific record? This seems like it would be a
    fairly fundamental action but I cannot figure out a code or way to actually
    do anything with the search form's results. Please help!!!!!!
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News New Orleans: Sikh holy book retrieved (Rediff.com) Breaking News Sep 11, 2005
    Sikh News Sikh holy book retrieved from under water (Hindustan Times) Breaking News Sep 10, 2005
    Sikh News UK Sikh Harnaam Kaur Enters Guinness Records As Youngest Female With Beard - The Indian Express Breaking News Sep 9, 2016
    Which "Three Inscriptions" Are Recorded? Intellectual Translations by SPNers Oct 11, 2015
    Amrita Sher-gil's Self-portrait Fetches A Record Record Price At Sotheby, New York Auction Sikh Personalities Mar 24, 2015

Share This Page