Editable Crosstab-like Form

[wnazzaro]

I am a db novice. I created the attached db and yesterday learned about multi value crosstab queries.

Today I learned that a crosstab query and related forms are not updateable .

If you open the attached db, you will find a form accessed by the FM Tracker button (Form_MultiValueCrosstab). I would like to create a dataentry form that looks like this. Is that possible? What is possible?

Background: We have locations that are selected for projects. A project has a status and a person assigned. Currently my crosstab form shows the status and the person. I would like my end users to be able to update the person (status is a calculated field).

All help is appreciated.

Best regards,
Bill

 

[Old Man Devin]

Can't say for sure, but I had a similar problem not too long ago, and the problem was that you can't have the recordset use joins between queries and still be updateable. So you could probably still get your updateable data-sheet view form, if the record source was just a single query/table. Looks like that might take some hefty restructuring of your data though, so in your specific case it might end up being a chore.

In my case it required using VBA functions to return some calculated values, rather than getting them through joins to other queries, which was annoying as it slowed the opening of the form down a fair bit, but it did work.