Form not write?

[Matthew]

I have a form based on a query:
SELECT lumber.price, psub.turning, psub.milling, psub.fluting, size.height,
size.width, psub.SKU, psub.Price AS psub_Price,
(([psub.turning]+[psub.milling]+[psub.fluting]+[lumber.price])*1.5) AS Expr1
FROM woodtype INNER JOIN (([size] INNER JOIN lumber ON
size.ID=lumber.sizeID) INNER JOIN psub ON size.ID=psub.sizeID) ON
(woodtype.ID=lumber.woodtypeID) AND (woodtype.ID=psub.woodtype_ID);

The form beeps instead of updating the data.

I tried making the form over, based on all the separate tables (not the
query) and it still didn't work.

Any ideas?

Matthew

 

[Duane Hookom]

Can you update the data when viewing the datasheet of the query?
Are the join fields based on Primary Keys on one side of the JOIN?

 

[Matthew]

I cannot update the data in the datasheet of the query.

All of the join fields have one side as the primary key.

Matthew

Can you update the data when viewing the datasheet of the query?
Are the join fields based on Primary Keys on one side of the JOIN?

--
Duane Hookom
MS Access MVP

I have a form based on a query:
SELECT lumber.price, psub.turning, psub.milling, psub.fluting, size.height,
size.width, psub.SKU, psub.Price AS psub_Price,
(([psub.turning]+[psub.milling]+[psub.fluting]+[lumber.price])*1.5) AS Expr1
FROM woodtype INNER JOIN (([size] INNER JOIN lumber ON
size.ID=lumber.sizeID) INNER JOIN psub ON size.ID=psub.sizeID) ON
(woodtype.ID=lumber.woodtypeID) AND (woodtype.ID=psub.woodtype_ID);

The form beeps instead of updating the data.

I tried making the form over, based on all the separate tables (not the
query) and it still didn't work.

Any ideas?

Matthew

 

[John Vinson]

I have a form based on a query:
SELECT lumber.price, psub.turning, psub.milling, psub.fluting, size.height,
size.width, psub.SKU, psub.Price AS psub_Price,
(([psub.turning]+[psub.milling]+[psub.fluting]+[lumber.price])*1.5) AS Expr1
FROM woodtype INNER JOIN (([size] INNER JOIN lumber ON
size.ID=lumber.sizeID) INNER JOIN psub ON size.ID=psub.sizeID) ON
(woodtype.ID=lumber.woodtypeID) AND (woodtype.ID=psub.woodtype_ID);

The form beeps instead of updating the data.

If you open this Query directly in datasheet view, is it updateable?
Note that a three-table Join often won't be; at the very least you'll
need to be sure that the joining fields (size.ID, woodtype.ID) have
unique Indexes in the "one" side table.

 

[Duane Hookom]

You may need to remove some tables from the query. Most of my forms are
built from just one or two tables. Other tables are added to the form as:
1) subforms
2) row sources of combo boxes or list boxes.

--
Duane Hookom
MS Access MVP

I cannot update the data in the datasheet of the query.

All of the join fields have one side as the primary key.

Matthew

Can you update the data when viewing the datasheet of the query?
Are the join fields based on Primary Keys on one side of the JOIN?

--
Duane Hookom
MS Access MVP

I have a form based on a query:
SELECT lumber.price, psub.turning, psub.milling, psub.fluting, size.height,
size.width, psub.SKU, psub.Price AS psub_Price,
(([psub.turning]+[psub.milling]+[psub.fluting]+[lumber.price])*1.5) AS Expr1
FROM woodtype INNER JOIN (([size] INNER JOIN lumber ON
size.ID=lumber.sizeID) INNER JOIN psub ON size.ID=psub.sizeID) ON
(woodtype.ID=lumber.woodtypeID) AND (woodtype.ID=psub.woodtype_ID);

The form beeps instead of updating the data.

I tried making the form over, based on all the separate tables (not the
query) and it still didn't work.

Any ideas?

Matthew