In Access, a newly added record cannot be seen in form view.

[ethomas]

I have a form which contains several subforms. When I add a record using the
form, I cannot see the record unless every subform is complete. How can I
change this so that each subform does not have to be complete when I
initially begin adding the record? The record shows up in the master table,
but not in form view.

 

[Dirk Goldgar]

"(e-mail address removed)12.nv.us"

I have a form which contains several subforms. When I add a record using
the
form, I cannot see the record unless every subform is complete. How can I
change this so that each subform does not have to be complete when I
initially begin adding the record? The record shows up in the master
table,
but not in form view.

I guess that your main form has its RecordSource property set to a query
that inner joins the master table with all (or at least some) of the related
tables that would be shown on the subforms. That would keep a record in the
master table from appearing on the form unless there was at least one
matching record in each of the related tables joined in the query.

In a form/subform arrangement, it shouldn't be necessary for the related
tables to be included in the main form's recordsource, since those tables'
records will be shown in the subforms. If my guess is correct, change the
main form's RecordSource to include only the master table.

 

[John W. Vinson]

I have a form which contains several subforms. When I add a record using the
form, I cannot see the record unless every subform is complete. How can I
change this so that each subform does not have to be complete when I
initially begin adding the record? The record shows up in the master table,
but not in form view.

It sounds like you've based the Form on a Query joining all the tables; this
is usually neither necessary nor a good idea! The form can be based on the
parent table (alone), and each subform on one of the child tables. What is the
Recordsource of the mainform?

 

[ethomas]

Hi John,

You were absolutely right. Once I followed your advice, everything worked
perfectly. Thank you!

 

[ethomas]

Hi Dick,

I followed your advice and was able to make the form work correctly. As you
suspected, I had included all of the fields in the master form, instead of
only the fields from that record source. Once I fixed that, and then
connected the subforms by linking the master and child fields, it worked
perfectly. Thank you for your help!

Ellen Thomas