Form not write?

M

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
 
D

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?
 
M

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

Duane Hookom said:
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


Matthew said:
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
 
J

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.
 
D

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


Matthew said:
I cannot update the data in the datasheet of the query.

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

Matthew

Duane Hookom said:
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


Matthew said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Form lookup with query 0
Lookup field 4

Top