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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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]
 
Back
Top