Easy one

[sms23]

Have a table with 5 fields. four are filled. Now have a query that shows me the records that I want to see. Now also have a form based on that query . Again that query has only four fields. Need to put some code behind this text box so that when I enter stuff in it updates records in the main table.

Table is like this

Product date weight ID(PK) Vendor

Tea 11/11/2004 1 1
Tea 11/11/2004 1 2
Coffee 11/11/2004 1 3
Coffee 11/12/2004 1 4

Query I do based on Product and date and gives me sum of Product on a given day.

So I have this for 11/11/2004

Product Sum of Product Weight

Tea 2 2

Now have a form based on the query. have the same fields fro the Query +
another text box called vendor. Now I want it to update the tea records when I enter some text into it.

Did I make sense

Regard

 

[Pat Hartman]

A query that aggregates data is not updatable. In your example, the row for Tea represents 2 records so Access will not allow any updates.

Don't you have some other table that contains product and vendor? Just link to the product table to pick up the vendor from there. You still won't be able to update the query but your form will show the associated vendor.

 

[sms23]

I will try that