no existing records shown on a continious form

  • Thread starter Thread starter Alex
  • Start date Start date
A

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
 
Alex said:
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
Click to expand...

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.
 
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?
Click to expand...

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
 
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.
 
Back
Top