Access 2010 Form Button Help

[spartanx117]

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

[June7]

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.