Sub form adding blank rows to table

[Morganpeet]

I have an order input form with a sub form for the invoice detail. The sub
form is linked to the main form by invoice number and customer name.
Everything is working OK but the sub form is adding the first row of the
invoice as 0 values - therefore when the invoice prints out it has a first
row of zeros!!

I have tried everything and can't work out where I have gone wrong, Please
help!!

 

[Roger Carlson]

Without knowing more about your tables, I can't tell you exactly what you're
doing. But your subform is allowing you to create an "empty" record. Make
sure at least one of the fields in the table your subform is based on has a
"Required" field that *does not* have a default value.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Jeanette Cunningham]

Hi Morganpeet,
the Northwind sample database for A2003 has a main form and subform for
orders and details.
Have a look at that to see how it works.
In A2003 click Help | Sample databases | Northwind

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia