Filter Form Record Based on multiple criteria

[diane802]

Hi - I have a form that is being used to enter data on individual clients.

I started a switchboard, which is what I want to use for the users to click through (instead of the access ribbon).

I already created a button that when clicked, opens a blank form for them to fill out.

How do i create a button that will have options for a user to type in (or drop down) these separate fields:
- Last Name


- First Name
- ID Number

Then, show the resulting records that match, and allow the user to select one of the records and open up the respective form.

I am thinking about this in terms of one record since I also have a command button on the form that opens up a report (printer friendly version of the form) that they would print, and I wouldn't want the user to end up printing multiple records if lets say there are 2 or more clients with the last name Smith.

Thank you!

[llkhoutx]

First of all, do not use blanks in field names. Blanks and special characters in field and control name cause a world of grief with SQL statements.

Assuming form field name LastName, FirstName & IDNumber build your forms Filter property in SQL without "WHERE " and set the form's FilterOn property to Yes on your button's OnClick event. Your code may be complicated if some of tose fields are not populated.

Additionally, have LastName, FirstName & IDNumber in a clearly identifiable part of you form - the form header is a good place with your button, so as not to confuse you user(s) that the field might be part of the form's bound controls.