I cant see my fields in form view.

K

kaitl

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

Gina Whipp

Kaitl,

Check the RecordSOurce for you subform it could be that it's not returning
an records OR you have set the Data Entry to Yes and you can't see the old
records.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
J

John W. Vinson

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

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).
 
D

David W. Fenton

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).
Click to expand...

Updatability is not the sole issue, but "Addability". That is,
AllowEdits has to be on (as well as AllowEdits).
 
J

John W. Vinson

Updatability is not the sole issue, but "Addability". That is,
AllowEdits has to be on (as well as AllowEdits).
Click to expand...

I'm sure David meant AllowAdditions.
 
Top