Update Query Results

[Guest]

I have a form that requests information that builds table record key. There
are two tables, primary record and secondary records tables working on a
one-to-many relationship. The form asks for Case-Yr and Case-Num, then based
upon query results on left join query between these tables, displays another
form with these records in it. It finds the records ok, but will not let me
change the data (non key pertinent data) in either of the records and I do
not understand why. Is there something, a switch or wording of the query
that I have to use.

Thanks in advance.

 

[Guest]

You can try it, but it's not always working

Try and change the UniqueRecords Property of the query to yes.