Record/Filter issue

[Guest]

When I added a record to the same vendor, that same record doesn't show up.
I have to filter for that specific record. But when I filter that specific
record it doesn't show that it's part of the vendor. And when I click on
Remove Filter/Sort it goes to totally different vendor. How I do fix this?

 

[John Vinson]

When I added a record to the same vendor, that same record doesn't show up.
I have to filter for that specific record. But when I filter that specific
record it doesn't show that it's part of the vendor. And when I click on
Remove Filter/Sort it goes to totally different vendor. How I do fix this?

Marie,

You can see your computer. You know your table structures, where the
Vendor field is, and what you're putting into the filter.

We do not.

Could you give us at least a little background? table structure (key
fields only, including the vendor field)? the Recordsource for the
form? the Filter property that's giving you trouble?

John W. Vinson[MVP]

 

[Guest]

It's weird because I see the records on the Datasheet view but not in the
actual data.

 

[John Vinson]

It's weird because I see the records on the Datasheet view but not in the
actual data.

The datasheet view (the Table) *IS* the actual data.

The problem is that your Form (I'm guessing - again, *I CANNOT SEE
YOUR DATABASE* and I have no idea how it's structured) has an error in
its recordsource query, so that the data which is in fact stored in
the table is not being displayed.

If you are assuming that data is stored in a Form, disabuse yourself
of this erroneous assumption! Data exists in tables, and *only* in
tables.

John W. Vinson[MVP]