Calculated data on Data Entry form

I

Ian Chappel

This is a generic problem I seem to have.

I have a Details subform (datasheet), where I wish to enter data as well as
view it. But also for each line (record) of the subform, there is
corresponding calculated/queried data.

I can create a query to provide this calculated/queried data, but then I
can't add new data. Is there a way to do this, preferably at query level? I
thought of using two side-by-side forms, but I'm sure there must be a better
method! Or basing the form on the table and using DLookup to bring in the
queried data? I'd like to do it just with a query if possible - I guess this
is more of a query question than a forms question.

If my problem's not clear, I'll provide an example.
 
A

Allen Browne

Just because you use a query doesn't mean your results are not updatable: it
depends what's in the query. You will therefore want to examine whether
there is something you can do (or remove from) the query so it is updatable.

For example:
How many tables are in the query?
How many of those tables are you trying to update fields from?
Does each table have a primary key?
Can you reduce the number of tables in the query?

For an explanation of what prevents a query from being updatable, see:
Why is my query read-only?
at:
http://allenbrowne.com/ser-61.html
 
I

Ian Chappel

Thanks Allen,

Not exactly sure what I've done, but it works now. Basically I had 3 tables,
one in the middle having two "many's", i.e. a many-to-many. I'm guessing the
order of the INNER JOIN's may have been in the wrong order?

I WILL study your subquery tutorials, and hopefully have a Eureka moment!
 
Top