extra record in subform

  • Thread starter Thread starter reportyemi
  • Start date Start date
R

reportyemi

I created 3 subform and placed them in a main form. When the first line are
filled and i look at the record afetr closing and reopening, one of the
subform that i filled always fills the second line as if it is another record
and leaves the first line blank. In other words, it really fills the second
line and not the top line. So when i print a report, that part of the report
is blank because the information has been placed in the second line as if it
is another record. I deleted the subform and recreated it and the same is
occuring. Very perplexing?? Can anyone help with this dilemma?
 
I created 3 subform and placed them in a main form. When the first line are
filled and i look at the record afetr closing and reopening, one of the
subform that i filled always fills the second line as if it is another record
and leaves the first line blank. In other words, it really fills the second
line and not the top line. So when i print a report, that part of the report
is blank because the information has been placed in the second line as if it
is another record. I deleted the subform and recreated it and the same is
occuring. Very perplexing?? Can anyone help with this dilemma?

I'm trying to figure out what would cause this behavior.

Have you opened the *table* itself (not a query, report or form) to
see if there's a blank record being added?

If so, it seems like you must have VBA or Macro code that is adding an
extra blank record.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com
 
Back
Top