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  

Problem with data displaying in form and layout view



 
 
Thread Tools Display Modes
  #1  
Old November 21st, 2008, 03:25 AM posted to microsoft.public.access.tablesdbdesign
cpwalle2829
external usenet poster
 
Posts: 2
Default Problem with data displaying in form and layout view

I was hoping someone could tell me why a form I am designing only displays
the data in design view. I am designing a form with a sub form and I have
built the queries. All the fields show up in only in design view. I have many
other forms with sub forms in my database and this is the only one that has
given me any problems. I have the feeling that it is something small (or at
least I hope it is.) Can someone point me in the right direction?
  #2  
Old November 21st, 2008, 12:32 PM posted to microsoft.public.access.tablesdbdesign
Fred
external usenet poster
 
Posts: 1,451
Default Problem with data displaying in form and layout view

Some confusion over design view may be confusing the issue.

Design view shows field names, not data. So the problem boils down no
data being visible in the form. One possibility is that there is no data in
the record source of the form. I'm assuming that you have data in the
tables that are ultimately the date source. I'd start by tracking this
backwards by directly viewing the record source of the form. If it's a
multi-table query, possibly it has join criteria looking directly at the
record sour If it's a query, possibly it has conditions which none of the
records meet or, if a multi-table query, record match conditions which no
pairs of records meet.

Sincerely,

Fred


So your actua
  #3  
Old November 21st, 2008, 07:21 PM posted to microsoft.public.access.tablesdbdesign
cpwalle2829
external usenet poster
 
Posts: 2
Default Problem with data displaying in form and layout view

Thanks Fred. This was actually the second time I was rebuilding the forms and
when I rebuilt the tables, I forgot to import the data from the previous
table. I spent hours trying to figure out where I went wrong and it was in
front of me the entire time. Thanks again for your input.


 




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 12:21 AM.


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