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.

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

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

I'm sure David meant AllowAdditions.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top