matching data between 2 combo lists

[Guest]

hi
i have secently started to use access and i need help on something.I have 2
combo lists lastname&firstname in the same table linking fom the same
table(one customer id). i select lastname and i want the selestion of
firstname to be of the matching lastname only.how do i do that? thnx

 

[Allen Browne]

Your table has fields like this:
CustomerID AutoNumber
LastName Text
FirstName Text

Your form has 2 combos?
One for LastName, and another for FirstName?
Would you consider combining these into one combo, so the user can select
the person by choosing their surname and first name at once? I generally
find that's easier and quicker to do.

If that sounds okay, use a combo with these properties:
Column Count 2
Bound Column 1
Column Widths 0
RowSource SELECT [CustomerID],
Trim([LastName] & ", " & [FirstName]) AS
FullName
FROM [Clients]
ORDER BY [LastName], [FirstName], [CustomerID];