WooHoo John! Yes, a little excited, but I got it to work. Apparently you
meant the subform. You don't know how much... well, maybe you do... how much
a relief this is.

It also helped me understand a little more database lingo too.

Have a Merry Christmas! Thanks again!

"John Vinson" wrote:

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

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.

Base the Form directly on the OrderDetails table. Put a Combo Box
(let's call it cboProduct) on the form bound to the ProductID field,
based on a query selecting the ProductID, product name, and product
price from the the Product Services Table.

On the Form put an unbound text box; set its Control Source to

=cboProduct.Column(2)

to display the third (it's zero based) field in the query, that is,
the price.

John W. Vinson[MVP]