Find Record

[amavadia]

Hi, i am a beginner to access and need some help if someone would be kind enough...
i have a table (tblCustomer) which has all the standard customer details such as name, address, phone etc. The primary key of the table is a autonumber field (Customer ID). i have autoformed it so all the fields are now on a blank form. I want to add a text box to the form so that i can find a record by typing the customer's surname. Once this has been searched, i would like the records to be listed in a table in a subform further down the original form. I would then like the user to select the correct record they are looking for from the sub form, and the details to come up in the main form so they can be edited. The reason for the whole sub form part is because there may be more than one customer with the same surname.
please could someone suggest how to achieve this.

thanks

 

[MStef]

Hello amavadia!

Look at "DemoCustomerA2000.mdb"

 

[amavadia]

Thanks for the reply mate
thats exactly what i have at the moment, but i want to make it so that to find a particular customers record, the user can type in the customers surname into a text box, click a button and it will lookup the details on that customer and display them in the form. However, if there are two customers with the same surname, this could be a problem, which is where the subform comes in. When the user searches for the customer, i want all the records with that surname to be displayed in the subform below, so that the user can choose the correct record they are looking for.

 

[ansentry]

You asked the same question before and I gave you same answer as MStef,
If you have a look at the small change I have made to the sample you will see that it will work. I have added first name so that you can find the correct person if they have the same surname.

http://www.access-programmers.co.uk/forums/showthread.php?p=479126#post479126