record sources

[kbreiss]

I have a form that uses two different queries to get all of the data. When I try to update this information within the form, down at the bottom it says this is not an updatable recordset. Is this because it is from two queries? Is there a way around this?

Thanks in advance,
Kacy
________
Extreme Vaporizer

 

[jjturner]

Haven't tried that before, but I would have to think that if one of those queries is a Totals query, then you absolutely cannot update records returned from running it by using a form.

In that particular case, the reasoning is straightforward:

Access would have to 'reverse-engineer' your Totals query to write to multiple records in the underlying table(s) for the single record that you're working on in the form.

Although the functionality for Referential Integrity invokes the use of multiple/cascading updates for a single field, that doesn't apply to a whole record, which may consist of multiple fields from multiple tables.

What you are attempting suggests that your table structure hasn't been normalized. Why do you need the values returned from stacked or combined queries to be updatable (presuming that is the case)?

HTH,
John

 

[kbreiss]

John,

I tried another query that linked the two together and it seemed to work. Thanks for the advice anyhow.

Thanks again,

Kacy
________
Sick From Depakote