Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2011
    Posts
    1

    Smile Unanswered: Query Based on User Input From Form Help

    I am new to Access and DBs obviously, but I am in need of a little help.

    I have a massive contacts similar database and information is constantly being updated in the records. I would like for the users to simply input say a ssn and have that retrieve the associated record. How would i go about setting this up? I know how to build quieres and reports I just dont know how to make the interface work and return a specific result in the way of an input form per say.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    try using the ssn as a filter
    so when you selext a specifric SSN
    set the value as a filter on the form
    apply the filter

    allow a mechanism for the user to remove the filter (usually another command button)
    I'd rather be riding on the Tiger 800 or the Norton

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
  •