Forms not working even using the wizard.

C

Chris

I have Access 2003. I've created a form with the form wizard and created a
form in design view. The problem is the form will not allow me to enter more
than just one entry. The allow additions and deletions are set to yes on the
form and on all the fields. I have made a form in design view and when I
switched to form view the form is blank. I don't understand what I'm
missing. Thanks for any help. I'm new to access and I'm trying to created a
database for work. Thanks again for any help.
 
R

Rick B

Switching a form to form view and seeing a blank screen indicates that there
are no records to be displayed and that you are not allowed to add any
records. What is your form based on? A query? If so, is the query
updateable? Can you add records through the query?

I have no idea why you would be allowed to add only one record in your other
issue. Generally, either you can add records, or you can't.
 
J

John Vinson

I have Access 2003. I've created a form with the form wizard and created a
form in design view. The problem is the form will not allow me to enter more
than just one entry. The allow additions and deletions are set to yes on the
form and on all the fields. I have made a form in design view and when I
switched to form view the form is blank. I don't understand what I'm
missing. Thanks for any help. I'm new to access and I'm trying to created a
database for work. Thanks again for any help.
Click to expand...

The problem is almost surely in the form's recordsource Query, not in
the form itself. What is the recordsource? If it's a query could you
post the SQL view of the query?


John W. Vinson[MVP]
 
C

Chris

It was in the recordsource query. I made the query an update query and the
form is working just fine. Thanks for the help. Thanks for pointing me in
the right direction on how to update a query.
 
Top