Hi all!
I have form based on one table with data to be entered and I'd like to include sum of data of a query.
It is basically sum of money obligated in a query that I'd like to be shown on a form where you can enter new data.
The problem is if I create a query (SELECT type) with all of the fields needed, I can't update nor enter new data any more.
I've tried entering same query in records source of that form but no luck there.
Any ideas?
EDIT: Please can moderator erase other double post. I had som problem with "Page not displayed" so I entered it twice by accident.
I have form based on one table with data to be entered and I'd like to include sum of data of a query.
It is basically sum of money obligated in a query that I'd like to be shown on a form where you can enter new data.
The problem is if I create a query (SELECT type) with all of the fields needed, I can't update nor enter new data any more.
I've tried entering same query in records source of that form but no luck there.
Any ideas?
EDIT: Please can moderator erase other double post. I had som problem with "Page not displayed" so I entered it twice by accident.
Last edited:
