no existing records shown on a continious form

[Alex]

Working on a continious form I'm entering some records
into a table. But, after closing this form and re-opening
it I cannot see these previously entered records despite
they exist in the table.

Could anybody clarify why it's happened?

Thanks

 

[Dirk Goldgar]

Working on a continious form I'm entering some records
into a table. But, after closing this form and re-opening
it I cannot see these previously entered records despite
they exist in the table.

Could anybody clarify why it's happened?

Thanks

Among the possibilities are:

1. The form's Data Entry property is set to True.

2. The form is based on a query with criteria that exclude the records
you're adding.

 

[Jim Allensworth]

Working on a continious form I'm entering some records
into a table. But, after closing this form and re-opening
it I cannot see these previously entered records despite
they exist in the table.

Could anybody clarify why it's happened?

It sounds like you have the form set to Data Entry. In design mode
check the forms properties window on the Data tab and see if the Data
Entry property is set to Yes.

- Jim

 

['69 Camaro]

Hi, Alex.

Inability to see new records after closing, then re-opening, the form, is
caused either by your Form's "Data Entry" Property being set to "Yes" or by
your new records being filtered out of the Form's Recordset.

First, check the Form's "Data Entry" Property (on the Properties "Data" tab)
and ensure that the "Data Entry" Property is set to "No."

If it already is, then check the Form's Record Source Property (also on the
Properties "Data" tab) to see whether it is based upon a saved query whose
criteria excludes your new records or whether there's a SQL statement that
also excludes your new records. If the Record Source Property isn't the
culprit, look at the VBA code to find a "Filter = ..." for this Form (the
code doesn't actually have to be in the Form's module, since your Form can
be referenced elsewhere) and a "FilterOn = True" somewhere that has criteria
that excludes your new records.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

 

[Alex]

Thanks a lot, everybody.
The Data Entry was set to Yes.

Regards,

Alex