Form will not load bound data

[Tangier]

Hi All

I have an Access 2002 database where I have forms that are bound to
tables. Usually when I open the forms, the form loads the bound
fields of the first record so that I can see it in the controls on the
form.

In this one particular form, it does not load the data from the table
consistently. Sometimes I see the bound data, sometimes it is blank.
ALthough I specified the controls in the field to be bound to a field
in a table, it does not always show.

What could be the problem here?

I use a list box to populate a "Site", instead of a combo box on the
other forms.

 

[Allen Browne]

Suggestions:

1. Make sure the form's Data Entry property is No. If you opened it with a
macro of code, make sure it was not opened in Add mode.

2. Click the button on the Toolbar to remove any filter.

3. If the tables are attached, make sure they are attached to the correct
database.

4. If the form's RecordSource is a query, check if the query's criteria or
joins are excluding your records.

5. Compact/Repair the database (in case there's a bad index.)