L
Larry
I would like to use a query to generate a list box that
pops up when entering data into a table. I would like the
query to run with a selection criterion that is provided
from the table, from a given record into which I am
entering data. Thus, when entering data into the specific
record, the first of two fields is specified, and the
second of the two fields is subsequently to be selected
from a list which is the dynaset obtained from running the
query, using as a criterion the first field's entry. Both
the first field's data and the second field's data are
taken from the same source table, upon which the query is
based.
I believe I know how to do all of this except the part of
passing the changing field criterion to the query on a
record-by-record basis.
pops up when entering data into a table. I would like the
query to run with a selection criterion that is provided
from the table, from a given record into which I am
entering data. Thus, when entering data into the specific
record, the first of two fields is specified, and the
second of the two fields is subsequently to be selected
from a list which is the dynaset obtained from running the
query, using as a criterion the first field's entry. Both
the first field's data and the second field's data are
taken from the same source table, upon which the query is
based.
I believe I know how to do all of this except the part of
passing the changing field criterion to the query on a
record-by-record basis.