View Single Post
  #3  
Old December 22nd, 2006, 11:57 PM posted to microsoft.public.access.forms
John Vinson
external usenet poster
 
Posts: 4,033
Default Subform has headings but not Cells to enter data???

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]