using a list form to display data 1

[techkenny1]

Hi all,
On a form with the default view set to single. The purpose of this form is to show client details.

Also on this form I have a created a list form, which shows all the clients in the database.
The list uses the same query as for the mainform (client)

What I want to do is to be able to select a client from the list and that data to show on the same form.

The query for the client part of the form is:
SELECT tblClient.RecordID, tblClient.StaffID, tblClient.BrokerStaffID, tblClient.Current, tblClient.BC, tblClient.Companyname, tblClient.Title, tblClient.Firstname, tblClient.LastName, tblClient.Language, tblClient.DOB, tblClient.CStreet, tblClient.Area, tblClient.CSuburb, tblClient.CCity, tblClient.CState, tblClient.CPostcode, tblClient.HomePhone, tblClient.Fax, tblClient.Mobile, tblClient.Email
FROM tblClient;

The row source for the list is;
SELECT [tblClient].[ClientID], [tblClient].[RecordID], [tblClient].[Firstname], [tblClient].[LastName] FROM [tblClient]

So when I select a client on the list I want the data to show on the client form?

Many thanks,
kp

 

[dhookom]

Have you tried adding a list box with the wizard and selecting the option to: "Find a record on my form based on the value I selected in my list box"?

Duane
Hook'D on Access
MS Access MVP

 

[techkenny1]

Hi Dhookham,
Many thanks for that reply. I will try that.

kp