Relating a drop down list to previous field

P

Phil Boorman

I have created a simple form that allows me to enter swimmers that have
progressed from one level to another. The last and first name fields on
this "move up" form use the same fields from the main registration form as
their control source. Is their any way to have the first name list
restricted to those names associated with the last name (there are many
siblings) rather than have a drop down list offering the first name of every
swimmer in the club?
 
J

John Vinson

I have created a simple form that allows me to enter swimmers that have
progressed from one level to another. The last and first name fields on
this "move up" form use the same fields from the main registration form as
their control source. Is their any way to have the first name list
restricted to those names associated with the last name (there are many
siblings) rather than have a drop down list offering the first name of every
swimmer in the club?
Click to expand...

I'd suggest a different approach: rather than two separate combo
boxes, use a single combo box based on a Query selecting the unique
swimmer ID (and if you don't have a unique ID, *you really need one!*)
and an expression

FullName: LastName & ", " & FirstName

This will let you select "Jones, Bill" or "Jones, Janet" or "Jones,
Xavier" at a single click.

If you really need the two combo boxes, see the example at the bottom
of the screen at

http://www.mvps.org/access/forms/frm0028.htm

John W. Vinson[MVP]
 
Top