Main-form and sub-form question.

[Guest]

I have a form so when I press this pull down menu of last names I select a
last name and it will show the person's information in a sub-form right
inside the main form. But when I get to look for a person with the same
lastname and I select it; it won't show up in the subform. Is it because it
is the same lastname? When I goto the next person in the list with a
different last name it's ok. Somebody help me!

 

[Guest]

Hi

It is important that your select the primary field in the "dropdown list"
(combo or list)

You need to include this is your record source for the "dropdown"

An example would be

SELECT [tableClients].[ClientID], [tableClients].[stName],
[tableClients].[Surname] FROM [tableClients] ORDER BY [Surname];

Column Count 3
Column Widths 0cm;2.54cm;2.54cm
Bound Column 1

When used like this is the "record" (with that person's details in it) that
your selecting not just the surname.

Hope this helps

 

[Guest]

That didn't work... is there anything I need to do to the Sub-form?

Hi

It is important that your select the primary field in the "dropdown list"
(combo or list)

You need to include this is your record source for the "dropdown"

An example would be

SELECT [tableClients].[ClientID], [tableClients].[stName],
[tableClients].[Surname] FROM [tableClients] ORDER BY [Surname];

Column Count 3
Column Widths 0cm;2.54cm;2.54cm
Bound Column 1

When used like this is the "record" (with that person's details in it) that
your selecting not just the surname.

Hope this helps






--
Wayne
Manchester, England.
Not an expert
Enjoy whatever it is you do

I have a form so when I press this pull down menu of last names I select a
last name and it will show the person's information in a sub-form right
inside the main form. But when I get to look for a person with the same
lastname and I select it; it won't show up in the subform. Is it because it
is the same lastname? When I goto the next person in the list with a
different last name it's ok. Somebody help me!