can't seem to add any editable text boxes

[qwertyjjj]

Hi
I have a form which retrieves and lists data from a query.
I need to add 2 textboxes on the end, which allow a user to add comments about the particular record, which are then saved directy to the database.
Unfortunately, the query has joins in it so it is impossible to have the data directly linked to a particular record in the database as per the following detail:
http://www.access-programmers.co.uk...=61901&highlight=query+multiple+source+update

So, any ideas about how to go about this? Ideally, it all needs to e on the same form.

Thanks.

 

[Fear Naught]

Having joins in the underlying query will not in itself stop you doing this unless as Pat says in your link the query aggregates data. I guess you need to look at your database design and the query under the form.

If you post the MDB I am sure somebody will help out.

 

[qwertyjjj]

Sorry, I meant to mention that. There is a group by clause in the query, which aggregates the data.
The comment boxes would be inked to a separate table.

Would some kind of subform work for the comments section?
If not, then I am left with the choice of entering all the aggreagted data into a separate table and having a Comments column in that???

 

[Fear Naught]

As I said above perhaps you need to look at the database design and particularly the query underlying the form. Do you really need a GROUP BY clause in the query?

If you want to be able to add multiple comments (not just 2 as mentioned at the beginning of the thread) then a sub form is the best way to do it.

 

[qwertyjjj]

Yeah it needs the group by as the query is summing data from various records. The group by threfore facilitates this.

To add a subform on the side, I will still need to link the record to the main form somehow. Is this possible? Perhaps with an expression in a hidden field linked to a box on the main form that has a primary key ?