extra record in subform

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?
 
A

Armen Stein

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top