Hi,

Latest problem I have is within a subform. I have a function that updates another field depending on its pulldown selection. It works but the function updates ALL records displayed in the subform. How does one specify that current record in the subform to be updated?

Thanks

You have to us a key on the table and refer to it in a WHERE clause.

For example:
UPDATE Table1 Set Field1 = Field2 WHERE Table1.Key = key

Note the above example is SQL server syntax Access SQL is different..

Hope this helps??
-Chris

If not more than one table involved, you can directly use the column name.

UPDATE Table_Name Set Field_tobeUpdated = Its_Value WHERE KeyField = keyValue

HTH
Cheers!

-Vijay G