Field input based on a list generated from a previous field's cont

[Guest]

I am trying to allow selection of a field's data to be a list that is
generated based on the contents of an adjacent (previously keyed or just
keyed in) field's contents. Any help would be greatly appreciated.
RJ

 

[John Vinson]

I am trying to allow selection of a field's data to be a list that is
generated based on the contents of an adjacent (previously keyed or just
keyed in) field's contents. Any help would be greatly appreciated.
RJ

Use a Combo Box based on a query which references the adjacent field:
create a Query based on the list table, using a criterion of

=[Forms]![YourFormName]![AdjacentFieldName]

to filter the list to the desired subset.

You'll also need one single line of VBA code; in the AfterUpdate event
of the AdjacentFieldName control, Requery the combo box.

John W. Vinson[MVP]