Search Function so that data will populate the form

[Somullins]

I have built a database where other users will be entering the data. The data entry form has a subform with data from another table. The main form is a constant (customer information) but the subform is for each transaction being recorded.

I want to be able to create a record search and edit function from the switchbox that filters by the customer id number then populates the data in both forms using a the design of the data entry form. I want to make this user friendly. I don't want to use a combo box because the database is going to be too big.

Any suggestions on the easiest way to do this?

 

[Simon_MT]

How do want to Search the Clients?

Simon

 

[Somullins]

By customer number which is the primary key. This is also a field for both tables.

 

[RainLover]

Any suggestions on the easiest way to do this?

One of the easiest ways to search is to use a Combo Box.

Why do you have a problem with them. Size is not an issue.

 

[Somullins]

I guess that I could. I thought it would get to be difficult to search as the database grows.

 

[RainLover]

There are other Methods if you have multiple Criteria, but for a Single search a Combo is fine.

Do you know how to set this up properly?

 

[Somullins]

I am in the process of setting up now. If you don't mind, please send me the steps in case I have trouble. Also, will this combox show the subform data as well? Will I need to build a second one in the subform?

 

[RainLover]

You should only need to one for the Main Form.

In design there is a Toolbox to allow you to add a Combo Box.

Use the wizard that comes with that.

The trick is to attach the Combo's search to the Table that has one record for each type.