Problem with data displaying in form and layout view

C

cpwalle2829

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

Fred

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
 
C

cpwalle2829

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.
 

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