Form/Subform - Creates blank entry in Table - Frustrating... HELP!!

[Meanfish]

Hi Guys and Gals,



I'm new to Access, but making pretty good headway on a database that I am creating for a charity project. I have an issue with a form/subform I have created to do multiple sales entries.

Form linked to Sales Table
Subform linked to Sales/Product Query

It works great except for 1 thing, it creates 1 black entry in the sales table when you enter the subform,

On the MainForm I have MembershipID and Date

In Subform, have Product, Quantity, Cost

The Parent/Child relations are MembershipID, Date and Product.

When you enter Membership ID and Date in the main form, its fine, but when you go to click on a product in the SubForm, a Blank Entry is generated in the sales table burning a SalesID. I can query past it, but it makes SalesID useless to me. It also generates an error message, 'You tried to enter Null value to a value that is not a variant data type' (the Product field - which is blank in the Sales Table.

I'm assuming that I need to stop the MainForm from creating a data entry before the subform is filled out.... but how **Shrug**

Tried to Attach DB, but it wouldn't upload it...... Please contact me and I can email it.

Thanks Heaps

Meanfish

[Rainlover]

Is the Main Form displaying the contents of the Sales Table and the Sub Form the contents of another Table.

If you can't upload your Database Describe the structure that you have. e.g.

tblSales

SalePK as Autonumber Primary Key.
Other Fields.

tblSalesDetalis

SaleDetailPK Autonumber Primary Key
SaleFK Number Foreign Key to tblSales
OtherFields.

If you could explain like this it would be a good start to solving your problem.

BTW You only need one Field to act as the Primary Key in any Table. AutoNumber is the best Data Type to use.