SUBFORM SHOWS A NEW "BLANK" RECORD

  • Thread starter Thread starter Chris Ryner
  • Start date Start date
C

Chris Ryner

I have a frmTENANTMST, bound to tblTENANTMST that contains 2 subforms.
frmRENTONLY source is qryRENTONLY
frmADDITION source is qryADDITION

when a record on the parent form has no records for the subforms to display
the RENT subform shows only the datasheet headers and no "record"
but the ADDITION subform shows the headers and a blank datasheet row.

when records are added to both subforms (via a popup edit form, as these
subforms have uneditable recordsets)
the RENT displays 1 line for 1 record
but the ADDITION subform displays the 1 line for the record and the * new
record blank line
even though these to subforms have the same properties and are intended to
DISPLAY details only.

The same thing happens when I just open the frmRENT or frmADDITION straight
from the database window
the rent shows only headers (when there is no data) but the other has a row
of blank boxes!!!!

What causes this and how can i get the ADDITION subform to not display this
new record line as it gives the
false impression of being able to enter data here. (not so) User must click
a button on the frmTENANTMST which
opens frmADDEDIT which allows the user to enter a new record or edit
existing records.

Any help would be appreciated as I have scoured the web, MSKB, and this
forum!!!!
 
John,
Both of the forms had the allow additions propertys set
to yes and only one form had the problem so I guess I
didn't think to check it. But this took care of the
problem.

Thank you very much for the "Fresh Pair of EYES!"
 
Back
Top