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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|