why i can't see my data in form view?

[Guest]

I am building my db and now in creating forms. Why is it that I cna't see my
data pages in form view though it is present in design view. did I do
something wrong?

i tried using wizard to create a new form but the problem persist. anybody
can help me please.

 

[John Vinson]

I am building my db and now in creating forms. Why is it that I cna't see my
data pages in form view though it is present in design view. did I do
something wrong?

Well, pretty clearly you did. Forms usually display data!

Could you explain? are these Data Access Pages, or Access Forms? Is
the data in Access or in some other program?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Guest]

It is just a simple db. I have created the table for company, rats et al. and
then create a query based on them. after that, just using wizard, I tried to
create the form based on the query. and nothing was shown in form view.

However, when I tried to create the form based on tables, it is visible in
form view. anything that I missed?

 

[Guest]

I just found out something. in form view, the 'filter by form' is active.
when I clicked it, then I can see the data. however, I can't go to the design
view from there. is there a way that I can switch off the 'filter by form'
function.

thanks

 

[John Vinson]

It is just a simple db. I have created the table for company, rats et al. and
then create a query based on them. after that, just using wizard, I tried to
create the form based on the query. and nothing was shown in form view.

This will happen when two things are both true:

- the Query doesn't return any records
- the Query is not updateable

If you open the query in datasheet view, do you see any data? And do
you see a *> "new record" line at the bottom? I'd guess not!

Normally a Form would NOT be based on a "grand master query" linking
all your tables. Instead, you can base a Form on the "one" side table
in a relationship, and Subforms on the "many" side tables. This
structure will typically be updateable and will display any existing
data.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps