Form is visible in design, blank when opened

H

Harold A. Mackey

I just designed a long form in Access 2003. The elements are only visible in
the design mode. The form is blank when opened.
Any suggestions?
Thanks
Hari
 
R

Rick B

That means that there are no records in the data source and your form does
not allow a new record to be added. If your form is based on a query, make
sure that query returns some records.

Rick B
 
H

Harold A. Mackey

Thanks for replying,
This form depends on many tables and there are many queries to fill dropdown
boxes that will be entered into other tables as results of the
questionnaire.I will begin by studying the existing queries.
Is there any global setting that would not allow the form to enter any data?
Thanks
 
R

Rick B

If the record source is updateable, then the form will be. Sounds like your
record source is built in such a way that you can't update the records
(one-to-many relationships?).

If you have a drop-down based on it's own query, that will have nothing to
do with the updatable status of the form. Only the main query upon which
the form is based will be considered. In most cases, you can simplify this
down to fewer tables (or simpler relationships) and then use subforms to
handle the one-to-many relationships.

Hopefully that will get you on track. Pretty complex issue.


Rick B
 
J

janaki

Hello Hari and Rick (and many others - this is a common question!) -

I struggled with this for the last 24 hours, and finally came across the
answer buried in the following documentation:

http://support.microsoft.com/default.aspx?scid=kb;en-us;304474
ACC2000: How to Edit Records in Related Tables in a Microsoft Access Database
Article ID: 304474

Data can't be updated:
Query or query field
Query based on three or more tables in which there is a many-to-one-to-many
relationship

Solution
Though you can't update the data in the query directly, you can update the
data in a form or data access page based on the query if the form's
RecordsetType property is set to Dynaset (Inconsistent Updates).

This may be your problem, it certainly was mine.....I have a main table with
my records, and there is one table that joins three other tables. One of
those joined tables is one-to-many join with the main table, and then the
main table is linked as the primary key in a one-to-many with the other two
tables.

Just setting the properties in the form so that RecordsetType = Dynaset
(Inconsistent Updates) solved the problem, and now my form shows up, and it
populates the correct tables!

Hurray!
janaki
 
Top