non-updateable problem

[Milothicus]

In my main table, each job has a value. over time, it can change, but i need to retain the original value, so i have another table that tracks the adjustments to the value. this of course, leads to a calculated field on my forms.

I have a search page on my form that includes searching for the calculated field for the current value. i've used a sub-query to sum the value revisions for each job, and included that in my search query.

i would like the recordset for the entire form to include only the results of the search, but if I include the search query anywhere in the recordset query, the recordset isn't updateable because of the calculated field.

is there a way to filter the recordset of the form based on the search query without using it in the recordset query?

 

[Milothicus]

I've used that on the form itself, but i want to include the result of the dsum on my search page. the only way i know how to set up a search is by using a query, with dynamic criteria based on text-entry or option controls on a form. to be able to search for certain total values, i need to calculate the totals in the query, and be able to filter them with criteria in the query.

the search works fine, and outputs to a listbox, and i can click on a record, and bring it up.

but...once you've clicked on a record and you're viewing it, using my first/last/previous/next buttons include all the records because the recordset is based on a different query, when i'd like them to cycle through only the records included in the results of the search.

i tried to use the search query as my recordset, but that didn't work (obviously)

i tried just showing the query on my recordset query page, with a join type 1 to my main table, but even though i didn't use any fields from that query in my main recordset query, it's still not updateable.

if there's a way to apply criteria to my calculated field outside a query, i guess that would work, but i don't know if that's even possible.

hope this clears something up.