Results 1 to 4 of 4
  1. #1
    diane802 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Dec 2009
    Posts
    92

    Creating a Switchboard button - search for record and open up specific form / report


    Hi -

    I am in the process of creating a main switchboard for users to utilize when they open a database.

    I already created a button, that allows them to use Form A to create a new record.

    How can I create a button that allows them to search for a specific record (via either the Primary Key ID, Last Name, First Name, etc) and then it will open up the Form A for them to edit this record?

    Also - how can I have them open up say a report that I create specific to that individual - the report will basically be a printer friendly version of the form - since it seems as though its hard to make a form printer friendly.

    Thank you!
    Diane

  2. #2
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    what you describe is not performed in a switchboard form; open the next form, then have a combo box at top to select the record for the form to go to....

    as to the report; in the form have a button that will open/print a report - - very common i.e. "Print" obviously you have to design a report that looks much like the form itself....

  3. #3
    diane802 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Dec 2009
    Posts
    92
    thanks NTC - I created the combo box up top to select the record for the form to go to..

    but is there no way to make this part of the switchboard? a way to have a pop-up that asks to type in Last name & First name, or ID, and then pop up the related records and give you an option to go to the form?

  4. #4
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    yes - one can customize; the way shown is the vanilla embedded method that Access offers without requiring customization.

    one can put the combobox in any other form, including the switchboard. then in the opening arguments of the target form one can refer to the value of the combobox - - or - - the target form can be sourced on a query - and the query uses criteria from the combobox.

    The second method may be easier for the beginner - not sure.

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

Similar Threads

  1. Print a specific record report from a form
    By cynthiacorley in forum Reports
    Replies: 27
    Last Post: 02-08-2010, 06:34 AM
  2. Replies: 7
    Last Post: 11-29-2009, 01:44 PM
  3. Replies: 5
    Last Post: 07-26-2009, 12:13 PM
  4. Open to specific form
    By ecpike in forum Forms
    Replies: 2
    Last Post: 06-12-2009, 08:32 AM
  5. Replies: 0
    Last Post: 10-16-2008, 02:39 PM

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