Deleted rows still showing up in background tables

[HGCanada]

RESOLVED: Deleted rows still showing up in background tables

Hi. I have a database with a form, which has a continuous subform. I've deleted rows of data via the form, and I no longer see them on the form, and yet they still seem to be in the table when I export the data. Any idea what is going wrong here?

Thanks.

 

[isladogs]

Look in the table your form is based on.
Have you actually deleted the records?

 

[arnelgp]

Do you have code for your delete maybe it only mark a field and got filtered out when you requery the form.

 

[HGCanada]

Thanks. I delete the records via the form. I shouldn't have to delete them through the tables, so I don't know why they are still there, in the tables.

I didn't write any code for deleting. The form should really cover all that, right? I have never seen this happen.

 

[HGCanada]

I think I figured something out. My forms seems to be filtering out of view records that have a blank value in one field, within that sub-form. I didn't do this on purpose. Any idea how I can get the form to show all the records, even if one of the fields on the subform is blank? Thanks!

 

[arnelgp]

Chk the source query
Or the forms filter property

 

[HGCanada]

Thank you. There was a weird remnant of a relationship I thought I had deleted, in the form properties. It was a data source issue. Resolved. Much appreciated.