Form is not finding the data

  • Thread starter Thread starter L.A. Lawyer
  • Start date Start date
L

L.A. Lawyer

I have a form that has a table as its source and is not filtered but shows
no data. I am able to put data into it, which is saved even thought Access
shows an error message that it is not saving the data.

I have tried deactiving all of the programming, which did not solve the
issue. I have turned allow filtering off. I have created copies of the
form and removed various controls; this also didn't help.

What am I missing?
 
I have a form that has a table as its source and is not filtered but
shows no data. I am able to put data into it, which is saved even
thought Access shows an error message that it is not saving the data.

I have tried deactiving all of the programming, which did not solve the
issue. I have turned allow filtering off. I have created copies of the
form and removed various controls; this also didn't help.

What am I missing?
Click to expand...

Check the DataEntry property of the form. It should be set to No.
 
This works, but now I can't add or change any data. What now?
Click to expand...

Is the DataEntry property *the only thing* you changed? Check the
following properties.

AllowEdits (yes)
AllowAdditions (yes)
AllowDeletion (yes)
RecordSourceType (Dynaset)

Open the RecordSource in datasheet view and see if you can make changes
there.
 
Back
Top