Everything was great until this. I have a form which the recordsource was built with the sql, query builder option. My form worked great and I could add or change anything I wanted to. But I had to have a way to keep track of price changes so I add a table. Then I had to use a make a query with the max function to only show the latest prices. so naturally I had to include this in the recordsource builder. Now I can't change or add anything, it says this recorset is not updateable. I need the max function and to be able to add or change anything in my form except for the price. Is this possible? Please help me.