Continuous Forms

[schmid]

I have a continuous form that I have attached to a query as a control
source. If I manually put the fields in the table they show great in
the form. If I try and add entries using the form, the next time I
open the form that entry is not there. It is not adding the entries I
make to the table. Do I need to relate a continuous form to the table
that I want the data to go into? Any ideas out there? Thanks in
advance!

Steve

 

[Carl Rapson]

Is the query updatable? In other words, if you open the query directly, can
you add records to it? If so, check to see if the form allows additions (the
AllowAdditions property is set to Yes).

Carl Rapson

 

[John W. Vinson]

I have a continuous form that I have attached to a query as a control
source.

As a Recordsource, not control source, I presume? Individual controls have
Control Sources; Forms have a Recordsource.

If I manually put the fields in the table they show great in
the form. If I try and add entries using the form, the next time I
open the form that entry is not there. It is not adding the entries I
make to the table. Do I need to relate a continuous form to the table
that I want the data to go into? Any ideas out there? Thanks in
advance!

Several possibilities. Have you perhaps set the form's Data Entry property to
True? if so, you'll see ONLY the new record, not existing data.

John W. Vinson [MVP]