same fields, different data???

[turkey]

i have table a and table b. in these 2 tables, i have a field n. field n is

inputed from different users so in table a, the data reads as xyz, and in
table b the data reads xyz-1. i am making a query that asks for parameter
from a 2'nd field--field s. field s is in table a. when field s parameter
is entered, i want field n in table b to be displayed. if the parameter i
asked for was for field n, then i would put like [feld n] & "*"--how would i
get field n in table b (xyz-1) going through a different parameter?
--

--

 

[John H W]

Use either the Lost_Focus or On_Change events. Write a function that takes
the appropriate field's data, write a query with that data, then display the
results of the query (or change its results as you see fit) in the field you
wish.

John H W

i have table a and table b. in these 2 tables, i have a field n. field n is

inputed from different users so in table a, the data reads as xyz, and in
table b the data reads xyz-1. i am making a query that asks for parameter
from a 2'nd field--field s. field s is in table a. when field s parameter
is entered, i want field n in table b to be displayed. if the parameter i
asked for was for field n, then i would put like [feld n] & "*"--how would i
get field n in table b (xyz-1) going through a different parameter?
--