A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

I cant see my fields in form view.



 
 
Thread Tools Display Modes
  #1  
Old January 22nd, 2010, 01:18 AM posted to microsoft.public.access.tablesdbdesign
kaitl
external usenet poster
 
Posts: 1
Default I cant see my fields in form view.

Created a subform on a tab. When I change back to form view the fields do
not appear. It is a blank box.
  #2  
Old January 22nd, 2010, 01:30 AM posted to microsoft.public.access.tablesdbdesign
Gina Whipp
external usenet poster
 
Posts: 3,500
Default I cant see my fields in form view.

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

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



  #3  
Old January 22nd, 2010, 01: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]
  #4  
Old January 22nd, 2010, 03:14 AM posted to microsoft.public.access.tablesdbdesign
Gina Whipp
external usenet poster
 
Posts: 3,500
Default I cant see my fields in form view.

John,

Okay, you did say it better then I did... g

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

"John W. Vinson" wrote in message
news
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]



  #5  
Old January 22nd, 2010, 11:19 PM posted to microsoft.public.access.tablesdbdesign
David W. Fenton
external usenet poster
 
Posts: 3,373
Default I cant see my fields in form view.

John W. Vinson wrote in
news
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).

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
  #6  
Old January 23rd, 2010, 02:26 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 22 Jan 2010 22:19:18 GMT, "David W. Fenton"
wrote:

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

John W. Vinson [MVP]
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:58 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.