hi.
i have a mainform with customer information that has a subform and is
linked by a custID. that works.
there are 3 ther fields on the subform. the subform has a table record
source with only the 4 fields. they are year, effective date, level.
the problem begins when i need to be able to select a year and call the
effective date based on the year. so i have an unbound combo box that does
a lookup for the effective date based on the year and custID. that's
working too.
so now all that's left is the level. i can look up the level the same way
as the effective date. and that works. but the user has to have the option
to lookup from a list and save the value.
the only one that will update is the first one in the table.
it seems it can't find my form or value or something.
can anyone help?
--
Message posted via http://www.accessmonster.com