Results 1 to 2 of 2
  1. #1
    spartanx117 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2012
    Posts
    3

    Access 2010 Form Button Help

    Hello, I am currently at a loss for what to do in my current project. I am creating a form that will pull up a customer’s data. It is possible the customer could have more than record, and I have three different distinct fields to help narrow to that exact customer. We have an ID field which would be primary key, their SSN which only relates to them, and their account # which also only relates to them. I am curious if there is a way for the form to not be populated when I start it, and either be able to type in a text box one of these 3 and have them linked to a query that will search for that record and fill the form with the data, or have it pull up a parameter box(can do, but cant get the data to populate in form view) I am not having any luck with using the command buttons, either they don’t work the way I want them to, or the data gets pulled up in a datasheet, instead of my form.


    I can manually filter on the ID numbers to find the record, but I’d rather make this user friendly for future users.

    Also the form currently houses 95 fields of data, but they fit very comfortably in the form.



    Access 2010

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    Could have form RecordSource with criteria parameters that reference the unbound search box with OR operators.

    SELECT * FROM tablename WHERE field1 = Forms!formname!box OR field2 = Forms!formname!box OR field3 = Forms!formname!box;

    Then need to Requery the form. In button Click event: Me.Requery.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 2
    Last Post: 10-26-2012, 01:18 PM
  2. Replies: 0
    Last Post: 07-31-2012, 12:25 PM
  3. Replies: 6
    Last Post: 02-18-2012, 07:20 AM
  4. Replies: 3
    Last Post: 11-15-2011, 06:29 PM
  5. Access 2010 Forms Command button Question
    By RayMilhon in forum Forms
    Replies: 3
    Last Post: 09-12-2011, 03:38 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