View Single Post
  #3  
Old January 22nd, 2010, 12:52 AM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default I cant see my fields in form view.

On Thu, 21 Jan 2010 16:18:01 -0800, kaitl
wrote:

Created a subform on a tab. When I change back to form view the fields do
not appear. It is a blank box.


This will happen when two conditions apply: the form's Recordsource returns no
records (so you can't see existing records), and it's not updateable (so you
can't see the blank new record either).

What is the Recordsource property of the subform? Post the SQL. If you open it
as a query datasheet, is there a * "new record" line at the bottom? (I'm
betting there isn't).
--

John W. Vinson [MVP]