Results 1 to 2 of 2
  1. #1
    bellczar is offline Novice
    Windows 8 Access 2007
    Join Date
    Feb 2013
    Posts
    9

    Need a form to invoke a second form given a condition

    My database (the only Access db I have) is one of managing my large record collection.

    I have a form in which I enter a song title in the box at the top and Access returns the first record matching that title or substring.

    I would like it to bring up a page of choices for those songs for which there are multiple songs with the same title. In the songs table, these songs
    have their own dummy record with only the song title (in the field "title") and the number 999 in the field "code1".

    For each title with code1= 999, there is a matching entry in a table called "dups". This table contains (1) the duplicated song titles; (2) a brief description of the songs in question; (3) the name of the unique record in the songs table (basically the title of the song followed by the name of one of the writers).

    For example, there are 10 songs with the title "My Love" in the database.

    The corresponding records in DUPS look like this:
    My Love Petula Clark hit My Love Hatch
    My Love Paul McCartney & Wings song My Love McCartney
    My Love Stevie Wonder song My Love Wonder
    My Love Lionel Richie hit My Love Richie
    My Love from "Candide" My Love Bernstein
    My Love recorded by Bing Crosby My Love Young
    etc.

    I recently ported this db to Access from an obsolete db system called KnowledgeMan. Attached is a screen shot of the page that appeared in KnowledgeMan. I would like to have something similar come up in Access.



    Obviously, I need to create a form called DUPS that displays the information from the DUPS table. I think I can do that, but then how do I get that form invoked from the main entry screen?

    Thanks in advance.
    Attached Thumbnails Attached Thumbnails dups screen.jpg  

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    In a continuous form ,show all records.
    in the form header , put a search box. In the AFTERUPDATE event of the box,

    Code:
    sub txtFind_afterupdate()
    If isnull(txtFind) then 
        Me.filterOn = false
    else
      me.filter= "[title]='" & txtFind & "'"
      me.filterOn=ttrue 
    end if

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

Similar Threads

  1. opening a form when condition is met
    By webisti in forum Programming
    Replies: 2
    Last Post: 03-06-2014, 02:39 AM
  2. Replies: 6
    Last Post: 08-08-2013, 01:00 PM
  3. where condition with Navigation form
    By hyman in forum Forms
    Replies: 0
    Last Post: 10-31-2012, 02:39 AM
  4. Replies: 5
    Last Post: 08-13-2010, 07:26 PM
  5. Where Condition - form error
    By catat in forum Forms
    Replies: 5
    Last Post: 07-15-2010, 07:40 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