Results 1 to 2 of 2
  1. #1
    deiry is offline Novice
    Windows 10 Office 365
    Join Date
    Nov 2020

    Add Search Box with Button on Switchboard

    Hi everyone,

    It's been a long time since I've used access and am struggling with one problem. On my switchboard I want to have a text box that I can type into and a button that executes the search in a particular field in my form. I want to form to open filtered to any matching records in its normal view (one record per page if that makes sense). Any results I have found by googling this subject has a new form being built to show the results and it shows them all in one page, this is not what I want.

    I appreciate any help!!! Thanks in advance!


  2. #2
    Welshgasman is offline Expert
    Windows 10 Access 2007
    Join Date
    Jan 2017
    Swansea,South Wales,UK
    Look at the DoCmd Openform statement and the WHERE parameter

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

Similar Threads

  1. Replies: 1
    Last Post: 01-22-2018, 02:23 PM
  2. Update Form Button on Switchboard
    By smarty84handsome in forum Access
    Replies: 7
    Last Post: 02-25-2012, 12:48 PM
  3. Switchboard button to open txt file
    By Dannat in forum Import/Export Data
    Replies: 17
    Last Post: 01-24-2012, 10:54 AM
  4. Password Protect button on Switchboard
    By rosaj in forum Access
    Replies: 1
    Last Post: 08-04-2011, 11:08 AM
  5. Replies: 3
    Last Post: 01-14-2010, 08:32 AM

Tags for this Thread

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 - Senior Forums