Yes, it is a form based upon a query. Now that you mentioned that, it makes
sense that it isn't update able. The reason I did it that way was so I could
select a product with a Lookup function and have its price pop up
accordingly. I haven't been able to figure out how to do it otherwise, even
using the Comprehensive Access Guide by Shelly Cashman.

This is just the query SQL, and I made it into form and inserted it into my
Orders Form (similar to Northwind) manually through the wizard.

Here is the SQL

SELECT [Order Details].[Product ID], [Product Services Table].[Product Price]
FROM [Product Services Table] INNER JOIN [Order Details] ON [Product
Services Table].[Product ID] = [Order Details].[Product ID]
ORDER BY [Order Details].[Product ID];

Any help would be appreciated. I'm trying to get this project done as a
Christmas Gift for a friend, and this is the only thing holding me up.

Thanks!

"John Vinson" wrote:

On Fri, 22 Dec 2006 15:32:00 -0800, EZ KEY
wrote:

I've created an Orders Form similar to that in Northwind, and have been
trying to learn by duplication. My Problem Is:

I finally managed to get my subform to insert into my Orders form in a
Dataview, however, the field heads show up but I'm not able to enter anything
into the fields? There are no "white cells" for information. What am I
missing?

I've been over and over it and have referred to Northwind alot but to no
success. Could really use some help.

My guess is that the Subform is based on a query that is not
updateable. What is its Recordsource? If it's a query, and you open
that query in datasheet view, is it updateable? If not, post the SQL
view of the query here and someone may be able to explain why and fix
it.

John W. Vinson[MVP]