access criteria

J

jim

when selecting a last name how do i get a pull-down of only the first names
that are associated with that particular last name

ie pick smith from data and then show all the first names that last name as
smith in a form using criteria or what ever
 
F

fredg

when selecting a last name how do i get a pull-down of only the first names
that are associated with that particular last name

ie pick smith from data and then show all the first names that last name as
smith in a form using criteria or what ever
Click to expand...

Here is one way:
Leave the rowsource of the first name combo box blank.

Code the LastName combo box's AfterUpdate event:

Me![ComboFirstName].Rowsource = "Select TableName.[FirstName] From
TableName Where TableName.[ComboLastName] = """ & Me.[ComboLastName] &
""" Order by YourTable.[FirstName];"
 
Top