Subform has headings but not Cells to enter data???

[Guest]

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.

 

[ruralguy via AccessMonster.com]

Do you have Allow Additions set to YES?

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.

 

[John Vinson]

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]

 

[Guest]

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!

 

[ezkey]

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!

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

[quoted text clipped - 6 lines]

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]

 

[John Vinson]

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]

 

[Guest]

Hi John! Thanks for your help.

Okay, a little naive, but let me reiterate. Are you saying to create a new
Orders form with this control box with a text box that will display the
information?
or...
Are you saying to do this to this all as a Subform in the Orders form?
Sorry to be stupid. I've been working on this for a week and a half and it
is very late.

Thanks!

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]

 

[Guest]

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!

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]

 

[John Vinson]

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.

I do know the feeling... and I do (very much!) appreciate the
feedback, and I'm glad I was able to help.

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

Have a Merry Christmas! Thanks again!

A merry Christmas to you, and to the friend who's getting the database
- glad I was able to "tie the bow on the package" for you!

John W. Vinson[MVP]