Form based on query

[Johny]

I got a form where admins can aprove orders or not by (un)checking the box "approved".
The recordsource of my form is a query that uses coloms from 3 tables.

My problem is that I can not change any record of my query. I can browse through the records but cannot change anything.
Properties of my form are all set, so this can not be the problem.

I know it must be something small I overlooked. I know it's somethin' to easy to post here but really can't seem to find this little thingie...

Any help would be appreciated,

thanx in advance,

Johny

 

[SQL_Hell]

Have you tried updating the data through the query, to see whether the join is the problem?

 

[Johny]

Well, when I open the query manually I cannot change the values of the recordfields either, I just see the records, that's all. It's just a simple selection query I made. When I look at the SQL code I see the "Group by" and "having" clausules. When I delete the "group by ..." and change "having" trough "where" I can change the values in the query and I can add new records to the query. But when I open the form that is based on this query I cannot see the data that is already in it, I can only add new records to the query...hmmzz

this action seems so common in access, why does this seem to be so hard for me, I know I overlooked somethin', but what :=/

 

[SQL_Hell]

do you have 'data entry' as true in the forms properties, as this will only let you enter new records.

 

[Johny]

yes, it's set to true. All properties of my form are set properly. Tried everythin'

 

[SQL_Hell]

That is why you can only add new records then, you want to set data entry to false

 

[Pat Hartman]

Queries that aggregate data are NOT updatable. Once you group multiple rows into a single row, how would jet identify the underlying rows to update them? You'll need to get rid of the group by and having clauses.

 

[Johny]

Queries that aggregate data are NOT updatable. Once you group multiple rows into a single row, how would jet identify the underlying rows to update them? You'll need to get rid of the group by and having clauses.

Since I don't really need those clauses, I deleted "group by" and changed "having" through "where". My query works fine now but when I open the form based on this query I can't view the data that is already in it. I can only add new records to it and browse through the records, that I added since I opened the form. How can I see the other records?

thanx for the replies,

Johny

 

[SQL_Hell]

Well as I said if you have data entry set to 'yes' on the forms properties, then you can only add new records.

Have you tried setting it to 'no'?

 

[Johny]

Well as I said if you have data entry set to 'yes' on the forms properties, then you can only add new records.

Have you tried setting it to 'no'?

Well, today I had to start all over again because I lost all my changes I made yesterday because of an internal error, so now I am finally where I was yesterday.
Still had the same prob,now I saw you were right, data entry was set to yes. So this was prolly the prob before too. I feel so stupid I overlooked this. It works just as I want it to be.
Thanx dude, really appreciate your effort.

Johny

 

[SQL_Hell]

Thats no worries mate,

You can use a form to make a data entry form and a form for viewing old records, the way you do this is by setting data entry to true when you open the form.........I find this quite useful.

The command to open a form and set it to data entry is as follows:


docmd.Openform,,,data Entry = true

Or something like that.

anyway I'm glad you sorted it out