Data in form not the same as in table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All,

I built a form based on a simple table,but when i look at the total rows in the navigation bar(on the form) i see less data rows then in the table.
theres is no mask/filter between the table and Form.
The solution was to clean all the fields on the form and re-enter them from the field-list in the form.
It happened to me more then once on different applications.
Does anybody knows this case and the reason for it?
Im working with Access 2003.
Thanks in advance,
AR
 
Is your form based on a query with a relationship between two tables? Is
this a one-to-many relationship? Or will you have cases where records may
exist only in one of the two tables?

Is this happening when you open the form fresh, or only after adding
records?

Rick B


Hi All,

I built a form based on a simple table,but when i look at the total rows in
the navigation bar(on the form) i see less data rows then in the table.
theres is no mask/filter between the table and Form.
The solution was to clean all the fields on the form and re-enter them from
the field-list in the form.
It happened to me more then once on different applications.
Does anybody knows this case and the reason for it?
Im working with Access 2003.
Thanks in advance,
AR
 
Back
Top